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

Document ID:  TEC1307005
Last Modified Date:  08/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Roscoe Interactive Environment

Releases

  • CA Roscoe Interactive Environment:Release:6.0

Components

  • CA ROSCOE. Interactive Environment:ROSCOE
Problem:

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.1 DB2 V10 CA Roscoe R6.0/SP09 CA 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)             

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >