What to do with SQLCODE = -144

[michel123]

Hello,

I wanted to create DB2 objects in a batch, and I got SQL error -144 which leaves me very perplexed. I have the following message:

DSNTIAD - SAMPLE DYNAMIC SQL PROGRAM 2.0

CREATE STOGROUP PGSG001
VOLUMES (FAN003)
VCAT PG8997
Error during SQL EXECUTE IMMEDIATE
SQLCODE = -144 DSNT408I, ERROR: INVALID SECTION NUMBER 1
SQLSTATE = 58003 SQLSTATE DSNT418I RETURN CODE
DSNT415I SQLERRP = DSNXERT SQL PROCEDURE ERROR DETECT
DSNT416I SQLERRD = -215 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD X'FFFFFF29 = 'X'00000000' X'00000000 'X'FFFFFFFF' X'000 00000 'SQL DIAGNOSTIC
INFORMATION

with the following JCL:

006500 / / EXEC PGM = PH01S01 IKJEFT01, DYNAMNBR = 20, COND = (4, LT)
006600 / / DD SYSOUT =* SYSTSPRT
006700 / / DD * SYSTSIN
006800 DSN SYSTEM (DB8G)
006900 RUN PROGRAM (DSNTIAD) PLAN (DSNTIA81) -
007000 LIB ('DSN810.RUNLIB.LOAD')
007100 / / SYSPRINT DD SYSOUT =*
007200 / / DD SYSOUT =* SYSUDUMP
007300 / / SYSIN DD *
007400
007410 CREATE STOGROUP PGSG001
007,420 VOLUME (FAN003)
007430 VCAT PG8997;


Thank you for your help.

[prino]

IBM gives this, but I doubt if it is going to be of any use. For me it most certainly is not. You might try your luck in on of the fora mentioned in the General Mainframe Info Links