Error message: RTN=106,RCODE=0133, DB2 SSID DSN IS NOT DEFINED IN THE CA-DB2 PARMLIB

Document ID : KB000054648
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Using Option 1) Quick EXPLAIN , the following error was displayed:
RTN=106,RCODE=0133, DB2 SSID DSN IS NOT DEFINED IN THE CA-DB2 PARMLIB.

The output of the requested option displayed the following:

.CALL EXPLAIN       
.DATA
   RULESSID = (DSN)                                                          
   ACM      = (N,DBA0132)                                                     
   VERSION  = (LATEST)                                                        
   STRATEGY = (TST1,,DBA0132)                                                 
   PLANTAB  = (ROLLBACK)                                                      
   CASE     = (UPPER)                                                         
   LINES    = (55)                                                            
   PROCDDF  = (N)                                                             
   FLOATFMT = (SCI)                                                           
   REPTFMT  = (OLD)                                                           
                                                                              
    PROCVIEW = (Y)                                                            
    EXPLTYPE = (FUTURE)                                                       
    PLANEXPL = (PACKAGE)                                                      
    ISOLATE  = (CS)                                                           
    TARGET   = (TST1(@DEFAULT))                                               
    PERFTIE  = (N)                                                            
    REPORT   = (SUMMARY,SUPPRPTS,ACCESS,PREDICATE/SHORT,DEPENDENCY/SHORT,     
                DEPENDENCY,STATISTICS,SQLRULE,PHYSRULE/SHORT,PREDRULE,        
                PLANRULE/SHORT,PLANRULE)                                      
    SRCPACK  = (TST1,LOCAL,BATCH,DB2BC900,,,)                                 
 .ENDDATA

Where did the (DSN) value come from for the RULESSID parameter?

Solution:

The (DSN) subsystem is populated from the Explain Options screen.
To access this screen from the Unicenter Plan Analyzer Main Menu, select Option 1) Quick EXPLAIN.

Option 1 displays the following:

r11.5     ----------------- PPA Quick Explain ---------------- 2008/08/27 14:5
COMMAND ===>                                                                  
                                                                              
---------------------------------------------------------------------- 
Location ===> LOCAL            DB2 SSID ===> D81B     Target SSID ===> DSN    
                                                                              
Specify the name of the plan or package that is to be explained or enter      
selection criteria to view a selection list.                                  
                                                                              
    Type           ===> P   ( P - Plan or K - Package )                       
                                                                              
    Plan/Collid    ===>                                                       
    DBRM/Package   ===>                                                       
                                                                              
    Selection List ===> Y   ( Y - Display plan or package selection list )    
                                    ( N - Execute explain with selection criteria )   
                                                                              
    Change Options ===> N   ( Y or N )                                        
                                                                              
    Profile        ===>                                                   
  
*************************************************************
*************************************************************

Change the "Change Options ===> N" parameter from "N" to "Y".

The "PPA Quick Explain - Explain Options" screen displays:

r11.5     -------- PPA Quick Explain - Explain Options -------- 2008/08/2 14:56
COMMAND ===>                                                                   
                                                                               
                                                                               
---------------------------------------------------------------------- 
  Database Options       ===> N        Historical Database Options             
  Primary AUTHID          ===>          Secondary AUTHID    ===>                
  Update SQL Qualifiers  ===> N        (Override Schemas & SQL/View Qualifiers)
  Rule Set SSID            ===> DSN     (Subsystem where Rule Sets are stored)  
  PLAN_TABLE Option    ===> R        (C - Commit, R - Rollback)              
  Explain Type             ===> F        (C - Current, F - Future)               
  Plan Explain Option     ===> P        (D - DBRM, P - Package, B - Both)       
  Non-Catalog Isolation  ===> CS       Optimization Hint   ===>                
  Process Views (Y, N)   ===> Y        Parallelism Degree  ===>                
                                                                               
  Target SSID               ===> DSN      Target Rule Set     ===> @DEFAULT       
  Uppercase Output       ===> Y        Access Path Filter  ===> N              
  Reports                     ===> Y        Search Conditions   ===> N              
  Catalog Statistics       ===> N        Search Filters      ===> N              
  Tie PERFORMANCE Data   ===> N                        
 
*************************************************************
*************************************************************

Change the Subsystem parameter in the "Rule Set SSID" to the Subsystem where the Rule Sets are stored.
Press PF3 and the RULESSID will be populated on the "PPA Batch Processor Card Display" with the Subsystem that you specified.

DSN is the installation default for the product.
This parameter is populated from one of three places:

  1. highlevel.PARMLIB, member PPA, parameter RULESSID (DSN) where DSN is replaced with the SSID
  2. the users own PPA Profile stored in the users ISPF profile dataset
  3. Plan Analyzer Administrative Functions (Option A), Explain Profile Maintenance (Option 4)
    Rule Set SSID        :  DSN     (Subsystem where Rule Sets are stored)