
Create a CICS IA UDB database
To create a CICS® IA® UDB database, follow these steps.
- Download the required files to your DB2® Windows workstation.
- You must download the following files to your workstation in ASCII
format.
- SCIUDAT2.UDB(CIUTRANS)
- SCIUDAT2.UDB(CIUTRCD)
- SCIUDAT2.UDB(CIUTSCD)
- SCIUSAMP.UDB(CIUUDBC)
- SCIUSAMP.UDB(CIUUDBT0)
- SCIUSAMP.UDB(CIUUDBT1)
- SCIUSAMP.UDB(CIUUDBT2)
- SCIUSAMP.UDB(CIUUDBT3)
- SCIUSAMP.UDB(CIUUDBT4)
- SCIUSAMP.UDB(CIUUDBT5)
- SCIUSAMP.UDB(CIUUDBT6)
Note:- The transfer of these files might create a blank line at the end of each file. If the blank line remains at the end of each file, a warning is issued during the create or load process. It is recommended that you edit and remove the last line if required.
- Depending on the method you use you might need to uncomment the CONNECT statement in the samples below.
- You must download the following files to your workstation in ASCII
format.
- Create the database:
- Review and edit the sample CIUUDBC.
- Use the DB2 Command Line Processor: db2 -td; -vf CIUUDBC > CIUUDBC.out
- Create the database objects:
- Review and edit the sample CIUUDBT0.
- Use the DB2 Command Line Processor: db2 -td; -vf CIUUDBT0 > CIUUDBT0.out
- Create the DB2 Stored Procedures, functions and triggers:
- Review and edit the sample CIUUDBT1.
- Use the DB2 Command Line Processor: db2 -td# -vf CIUUDBT1 > CIUUDBT1.out
- Load the static DB2 tables:
- Load the CIU_VERSION table.
- Review and edit the sample CIUUDBT2.
- Use the DB2 Command Line Processor: db2 -td; -vf CIUUDBT2 > CIUUDBT2.out
- Load the rest of the static tables.
- Create and edit the static.in file:
CONNECT TO _udbname_; SET SCHEMA _udbqual_; import from CIUTSCD of del insert into _udbqual_.CIU_THREADSAFE_CMD; import from CIUTRANS of del insert into _udbqual_.CIU_TRANSLATORS; import from CIUTRCD of del insert into _udbqual_.CIU_TRUEEXIT_INFO; COMMIT;
- Use the DB2 Command Line Processor: db2 -td; -vf static.in > static.out
- Create and edit the static.in file:
- Load the CIU_VERSION table.
