From CA Roscoe DB2 option, the SELECT * command was not displayed for DB2 V10.

Products

• Roscoe

Issue/Introduction

After upgraded DB2 from V9 to V10, the SELECT * command result of table was not displayed from Roscoe DB2 option.
The IBM SPUFI outputs it without a problem.

 

Command;
SELECT * FROM SYSIBM.SYSINDEXES

 

Result;
-----------------------------------------------------------------------------
RUST803 RESULT COLUMN INVALID SQLTYPE CODE = 00904
-----------------------------------------------------------------------------
RUST200 SQL COMMIT EXECUTED
RUST002 STATEMENT EXECUTION SUCCESSFUL SQLCODE = 0
-----------------------------------------------------------------------------
RUST005 INPUT STATEMENTS READ 1
RUST004 SQL STATEMENTS EXECUTED 1
RUST006 ERRORS DETECTED 0
RUST007 OUTPUT LINES WRITTEN 12

Environment

z/OS 2.1DB2 V10CA Roscoe R6.0/SP09CA Roscoe DB2 R6.0/G9412.

Cause

The DB2 data type(ROWID) was not being recognized as valid data type by CA Roscoe.
Since the result of SELECT * contains ROWID information, CA Roscoe was not able to output the result.

 

Resolution

Please apply the RO97223 and rebind the RUSTIPCS and RUSTIPRR.

A new DB2 BIND is required on the RUSTDBRM module after applying the APAR.
Please use Option 3 on the CA ROSCOE TO DB2 menu screen to rebind RUSTIPCS and RUSTIPRR as described in Install Guide.

Following are samples for RUSTIPCS, RUSTIPRR:

                      CREATE APPLICATION PLAN                 
                                                              
DBRM  RUSTDBRM                                                
                                                              
DBRMLIB   ===> CAI.RO60OPT                                    
                                                              
                                                              
                                                              
PLAN NAME        ===> RUSTIPCS       (NAME OF APPLICATION PLAN)
OWNER            ===>                (AUTHID OF OWNER)        
ACTION           ===> REPLACE        (ADD OR REPLACE)         
RETAIN EXEC AUTH ===> YES            (YES OR NO)              
ISOLATION        ===> CS             (CS OR RR)               
VALIDATION TIME  ===> BIND           (RUN OR BIND)            
ACQUISTION TIME  ===> USE            (USE OR ALLOCATE)        
RELEASE TIME     ===> COMMIT         (COMMIT OR DEALLOCATE)   
EXPLAIN PATH     ===> NO             (YES OR NO)              
ERROR MSG LEVEL  ===> I              (I, W, E, C)             
                                                              
                                                              
                      CREATE APPLICATION PLAN                 
                                                              
DBRM  RUSTDBRM                                                
                                                              
DBRMLIB   ===> CAI.RO60OPT                                    
                                                              
                                                              
                                                              
PLAN NAME        ===> RUSTIPRR       (NAME OF APPLICATION PLAN)
OWNER            ===>                (AUTHID OF OWNER)        
ACTION           ===> REPLACE        (ADD OR REPLACE)         
RETAIN EXEC AUTH ===> YES            (YES OR NO)              
ISOLATION        ===> RR             (CS OR RR)               
VALIDATION TIME  ===> BIND           (RUN OR BIND)            
ACQUISTION TIME  ===> USE            (USE OR ALLOCATE)        
RELEASE TIME     ===> COMMIT         (COMMIT OR DEALLOCATE)   
EXPLAIN PATH     ===> NO             (YES OR NO)              
ERROR MSG LEVEL  ===> I              (I, W, E, C)