DB2 considerations

Before running the installation jobs to create the DB2® environment you must consider and decide the following questions.

Start of change

DB2 versions

CICS IA supports DB2 Version 8.1 and above. If you are planning to install CICS IA with a DB2 Version running in compatibility mode then please make sure that you set the DB2 Compatability Mode option to YES when you use the supplied configuration exec.

End of change

DB2 access

On any region, on which you intend to collect DB2 data, ensure that the user ID, under which the CINB transaction runs, has permission to access the SYSIBM.SYSPACKSTMT and SYSIBM.SYSSTMT DB2 tables. You can get this access by giving the user ID access to the CICS IA plan for the CINB transaction. See section Granting access to the plans and tables.

The user ID under which the CINB transaction runs is dependent on how CICS IA is activated when using CINT. In most cases, the "CICS default user ID" is used. However, there are cases where it might be the PLT user ID if started by PLT processing, the ID of the current CINT transaction, or the "Link ID" if the CINT transaction is routed to another CICS region.

The batch jobs to load all CICS IA database use the DB2 LOAD and UNLOAD utilities. The RACF® user ID or group used for these jobs requires DB2 Application Development Manager authority on the CICS IA database.

Read this section in conjunction with the CICS DB2 Guide


Concept Concept

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//ciuug3b.html