B204 SQL - PLAN "DQPS024" NOT FOUND error

Document ID : KB000047963
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Where does "DQPS024" reside? Is it an Easytrieve or Pan/SQL module? How is it created?

Solution:

DQPS024 is a plan/member which is created when you run the IJ3STGE1 job, located in your CA Pan/SQL JCL library.

It is created and placed into the DBRMLIB you have specified and which already exists.

In IJ3STGE1, executing EXEC PGM=DSNHPC creates the DBRMLIB member DQPS024.

You can either create the DBRMLIB prior to running the IJ3STGE1 or use an existing one.

Informational apar QI44120 explains how to create one and has this information for you:


//your job card, // //******************************************************* //*                                                     * //*  CREATE DBRMLIB                                     * //*                                                     * //******************************************************* //CRTELIB  EXEC  PGM=IEFBR14 //DD5    DD  DSN=your.DBRMLIB, //     DISP=(NEW,CATLG,DELETE), //     DCB=(RECFM=FB,LRECL=80,BLKSIZE=3200), //     UNIT=SYSDA,SPACE=(CYL,(1,1,2)),VOL=SER=volser //*

After you run the IJ3STGE1 job to create the CA Pan/SQL plan, please be sure to also run the CB2ACMDL job.

The SQLINST4 job should also be run if you have more than one subsystem.