Start of change

Create a CICS IA UDB database

To create a CICS® IA® UDB database, follow these steps.

  1. 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.
  2. Create the database:
    1. Review and edit the sample CIUUDBC.
    2. Use the DB2 Command Line Processor: db2 -td; -vf CIUUDBC > CIUUDBC.out
  3. Create the database objects:
    1. Review and edit the sample CIUUDBT0.
    2. Use the DB2 Command Line Processor: db2 -td; -vf CIUUDBT0 > CIUUDBT0.out
  4. Create the DB2 Stored Procedures, functions and triggers:
    1. Review and edit the sample CIUUDBT1.
    2. Use the DB2 Command Line Processor: db2 -td# -vf CIUUDBT1 > CIUUDBT1.out
  5. Load the static DB2 tables:
    1. Load the CIU_VERSION table.
      • Review and edit the sample CIUUDBT2.
      • Use the DB2 Command Line Processor: db2 -td; -vf CIUUDBT2 > CIUUDBT2.out
    2. 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
End of change