MVSFORUMS.com

shekar123

Hi,

I am trying to unload data from a db2 table where i am using the utility DSNTIAUL but i am getting a RC of 12 with the error

READY
DSN SYSTEM(DSN)
IKJ45200I COMMAND DSN NOT FOUND
READY
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) LIB('DSNDBA.DB2.RUNLIB.LOAD')
IKJ56712I INVALID KEYWORD, PLAN(DSNTIAUL)
READY
END

I have looked out for the member DSNTIAUL in the library DSNDBA.DB2.RUNLIB.LOAD and it is found.I have checked in SPUFI as to which Sub System id i am using and it is SSID: DSN only. Can anyone help me out the reason for my job being failed ? Is there any way we can find out which Sub Sytem are we using other than as seen in SPUFI ? I guess if we give correct SSID ,the job might be successful.Please guide me how to proceed further.

ANIL SARATHY · Posted: Sun Oct 23, 2005 10:48 pm Post subject:

I think problem is with DSN SYSTEM.
Can you check it again.

Okay , what subsytem is used for production then ..... .
_________________
Anil Sarathy

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

When after the READY prompt it states "DSN SYSTEM(DSN)" you are in fact calling a load module called DSN, which ist the "DB2 command line processor". This load module has to be allocated to your job step.

Therefore look at the steplib cancatination of your JCL and make shure that the DB2 system load library containing the load module DSN is present.

regards
Christian

shekar123 · Posted: Mon Oct 24, 2005 6:10 am Post subject: unable to download db2 data

Thanks Christian,

You are correct the steplib i was using did not contain the load module DSN ,so i copied from other dataset and able to proceed ahead but still i am getting -922 error:

SQLCODE = -922, ERROR: AUTHORIZATION FAILURE: PLAN ACCESS ERROR.
PLAN DSNTIAUL NOT AUTHORIZED FOR SUBSYSTEM DSN AND AUTH ID USERID.

Is it because i do not have the access to the plan DSNTIAUL for the subsystem ? Can u please guide me ahead ?

Thanks
Shekar123

Manas Biswal · Posted: Mon Oct 24, 2005 8:59 am Post subject:

shekar123,

The error message is self-explanatory.
First of all check that the DSNTIAUL plan is bound to the DB2 subsystem DSN. Connect to the DSN subsystem and check the SYSIBM.SYSPLAN table. It should contain an entry for DSNTIAUL. Check whether the plan entry is valid and operative.
If an entry is present, check the SYSIBM.SYSPLANAUTH table to see if your userid has execute access on the DSNTIAUL plan.

HTH....Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

shekar123 · Posted: Mon Oct 24, 2005 2:36 pm Post subject: load data jcl parameters needed

Thanks Manas for your reply as i checked in the tables SYSIBM.SYSPLAN & SYSIBM.SYSPLANAUTH refered by you ,the plan name is not active and valid ,so my userid did have the authority too and i got this done by my DBA and i was able to unload successfully.

I have a query as while loading data into a DB2 table ,i am using the jcl like this

//LOAD EXEC DSPUPROC,SYSTEM=DSNT,UID='ABCDEF',UTPROC=''
//STEPLIB DD DSN=DSNDBA.DB2.RUNLIB.LOAD,DISP=SHR

My understanding is that we are executing a procedure DSPUPROC and passing the parameters UID and UTPROC.I searched for the member DSPUPROC in the library SYS1.PROCLIB but i could not find the member ,Can we execute the JCL successfully and where can i find that member to see whether it exists or not.Morever how do i know what value should i pass for UID parameter ,is there any way where i can find the value for it and i have seen in many JCLS UTPROC parameter is always set to blanks,why is that set to blanks .Please guide me as i am trying to load and unload data DB2 data.

Manas Biswal · Posted: Tue Oct 25, 2005 3:39 pm Post subject:

shekar123,

As they say - "A manual is worth a thousand words"..- Smile

Follow this link to the complete description of DSNUPROC - the guide is DB2 for Z/OS v7 Utility guide and reference. You will find all your answers here.
Feel free to get back if you still have doubts.

[url]
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnugh17/2.1.5?DT=20050720160716
[/url]

HTH...Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

shekar123 · Posted: Tue Oct 25, 2005 4:15 pm Post subject: load data jcl parameters needed

Thanks Manas,

Your reply suggested me to go through the link for the utility DSNUPROC and i was able understand and implement in my UNLOAD jcl and i was successful .I was bit confused with one of the paramter UID to use,but it takes default USERID.JOBNAME and it was a nice learning experience.

Bye
Shekar123

Manas Biswal · Posted: Wed Oct 26, 2005 8:56 am Post subject:

shekar123,

The UID is the utility identifier that DB2 uses to uniquely identify the utility. This UID is also used if you want to restart the utility or run commands against the utility. Commands like -DIS UTIL or -TERM UTIL identify the utility by the UID. The default is Userid.Jobname, but I would highly recommend using a UID according to your shop's naming standard. The maximum length of this parameter is 16 chars.
For example, if you are doing a LOAD to the tablespace - TS1, you can have a UID of "LOADTS1".
You cannot run utilities with duplicate UIDs.
HTH....Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)