Catalog new Database

[tony simper]

hi all, I hope this is the correct place and forum for this.

We are a long-time Datacom shop (although I am not so experienced myself), and we just recently looked at using SQL for our new Test DB creation and update.

I set up a minimal DB using DBSQLPR with this :

CREATE DATABASE STUWD997_INFORMATION DATACOM
DATACOM_ID 997;
COMMIT WORK;

 

This gave me an RC=0 so I assumed this is now on the Dictionary. a -RPT showed it there as version 0001.

 

I then tried to run a DDCFBLD to move it into the CXX (per KB TEC1047513) but this fails:

 

*-------------------------------------------------------------------------------
* CODE FUNCTION,ENTITY-TYPE,OCCURRENCE(VERS,PSWD,OVRD)
* -CXX CATALOG,DATABASE,STUWD997_INFORMATION(0001) ; MS
* TRANSACTION ERROR: DDFCFM0033 INVALID ENTITY-NAME
*-------------------------------------------------------------------------------

 

One thing I noticed in the inherited JCL was that I had an AUTHID set in the creation, but used a different user (DATACOM-INSTALL) in the DDCFBLD.

 

Could that discrepancy have caused this ? Otherwise I am a little confused as to why my newly created DB cannot be seen.

Thanks in advance for any advice.

Tony Simper

[Dale Russell]

tsimper

 

Please open a case with CA Support so we can help you get to the bottom of this problem.

 

Dale_Russell

[tony simper]

Thanks Dale, I have opened a case now.

[Karina Pulinx]

Hi Tony, 

 

With each SQL CREATE statement a CXX CATALOG is being executed under the covers. 
So that happens when you run that CREATE DATABASE, CREATE AREA and then again when running CREATE TABLE. 

 

example : 

 

CREATE TABLE SYSUSR.STTTABLE 
(STTTABLE_KEY CHARACTER(5)) IN STTAREA DATACOM NAME STA; 
COMMIT; 

 

The database entity status gets changed from Q into P for PROD. 
If you run DBUTLTY REPORT AREA=CXX,DBID=997 you see that the base has been cataloged in P001 status. 
At this point you can run DBUTLTY INIT on the IXX and the data area STA and run a load format none. 
Then you can insert records in this new table. 

 

Your MUF should be started with mode DATACOM in the SQLOPTION card. 

 

Regards,Karina.