How to install CA DATACOM SQL option in an existing CA Datacom 11.0  z/VSE  environment ?

Document created by KarinaPulinx Employee on Oct 8, 2015
Version 1Show Document
  • View in full screen mode

Before you start the  SQL product  installation find out how large the  z/VSE partition is where the Multi-User is running  

and  how much GETVIS is still free in this partition when all URTs have been opened in CICS .

You can run z/VSE console command GETVIS xx where xx is the partition-id where the Multi-User is running

to check out the LARGEST FREE size .

 

Adding SQL requires a minimum of 6M of GETVIS .

We recommend a minimum MUF partition size of 16M (depending on the number of buffers specified in the MUF startup 16M might be too small )

for CA Datacom version 11.0  and for  version 12.0 32M is recommended .

CA Datacom SQL version 12.0 uses IBM C and requires more .

 

Check via CA? on the z/VSE console what version and service pack of CA Datacom you are running .

Of course you can also check  message  DB00215I  when the MUF enables .

Example : DB00215I - CA Datacom/DB r11 at service pack: SP05

The service pack levels for DB and SQL need to be the same .

 

SQL requires system tables in areas MSG and SIT in DBID 015 .

Those areas were not  created when you ran the CA Datacom/DB installation .

Our CA Datacom installation guide for z/VSE documents the steps to install SQL but

nothing is mentioned about these needed system tables for SQL .

Define  these 2 areas  by running  :

 

 

*** step one ***

Stop all  activity on DBID 2 and 15  . 

 

*** step two - DEFINE SIT015 AND MSG015 (DBID015 FILE) ***

Run DDUPDATE using

-USR DATACOM-INSTALL,NEWUSER 

-UPD DATABASE,DDD-DATABASE(PROD,DD)

1000 RESTORE,T001

-END

--- cards from attached DBID015.TXT  file --- 

 

*** step 3 - SET AND VERIFY ***

Run DDUPDATE using

-USR DATACOM-INSTALL,NEWUSER

-UPD DATABASE,DDD-DATABASE(T001,DD)

1000 SET

1000 VERIFY

-END

note that the VERIFY will give DDWKEY0013 SIGNED NUMERIC FIELD IN KEY but those messages are OK

 

*** step 4 - COPY THE DATABASE FROM T001 TO PROD ***

Run DDUPDATE using

-USR DATACOM-INSTALL,NEWUSER

-CPY DATABASE,DDD-DATABASE(T001,DD),PROD 

 

*** step 5 - BUILD THE DDD-DATABASE ***

// ASSGN SYS023,DISK,VOL=******,SHR

// DLBL DDCFBLD,'&D11PFX..CFMWORK',,SD

// EXTENT SYS023,******,,,1,60

// EXEC DDCFBLD,SIZE=320K

-USR DATACOM-INSTALL,NEWUSER

-CXX BUILD,DATABASE,DDD-DATABASE(PROD,DD,PRIV)

 

*** step 6 - PERFORM CXXMAINT to update the CXX  ***

// ASSGN SYSnnn,DISK,VOL=******,SHR

// DLBL DDCFBLD,'&D11PFX..CFMWORK',,SD

// EXTENT SYSnnn,******

// EXEC DBUTLTY,SIZE=512K

COMM OPTION=CLOSE,DBID=015

CXXMAINT OPTION=DDPROD,DEVICE=DISK,DTFNAME=DDCFBLD

 

 

*** step 7 -  add  files in Standard Labels  ***

--- ADD THESE FILES TO standard labels ---

// DLBL SIT015,'&D11PFX..SIT015',9999,DA

// EXTENT SYSnnn,******,1,0,????,400

// DLBL MSG015,'D&D11PFX..MSG015',9999,DA

// EXTENT SYSnnn,******,1,0,????,250

--- END standard labels ADD ---

/*

 

*** step 8  initialize the new areas ***  

 

Run DBUTLTY

INIT AREA=SIT,DBID=015

INIT AREA=MSG,DBID=015

LOAD AREA=SIT,DBID=015,FORMAT=NONE

LOAD AREA=MSG,DBID=015,FORMAT=NONE

/*

 

*** step 9 bounce the Multi-User  ***

Shutdown and restart the MUF gracefully

 

 

 

Now follow the SQL installation steps as documented in the CA Datacom Installation Guide .

  1. 5.3.1 Advantage CA-Datacom SQL Option

The external disk files are required for this option.

Retrieve member BEINS01S.Z from the CAI110.SAMPJCL library. Select the

parameters for the SQL option and submit. The following members are

  1. produced.

■ BEINS04A.Z

■ BEINS14A.Z

■ BENEW05A.Z

■ BEIVP02.Z

■ BEIVP03.Z

 

After downloading the SQL product code from tape (or AWS) by running BEINS04A it is recommended to  install all published PTFs on top of  the service pack level that you are running . You can find them on CA Support Online – Datacom product page  - click on Maintenance Grid for z/VSE  .

 

 

Run  BEINS14A and BENEW05A .

You have now  installed SQL DBIDs 16 and 17 .

Modify the Datacom Multi-User startup JCL by adding

the DLBL/EXTENT cards for all areas in DBID 16 and 17  ( or put them in Standard Labels   ) and

add following MUF startup  cards :

DATACOM SQL

SQLDEFAULT 16,CASQLDEFAULT

SQLOPTION YES,17,DATACOM,120,NO,NO

 

Start the Multi-User .

You should see message DB00212I - SQL ENVIRONMENT ESTABLISHED .

 

Now that you have the MUF enabled with SQL you can run the SQL installation verification job BEIVP02 .

BEIVP03 is optional .

 

Attachments

Outcomes