Page 1 of 1

DB2 LOAD

PostPosted: Sun Mar 16, 2014 7:16 am
by tdanielxyz
DB2 load

--------------------------------------------------------------------------------
I tried to use a JCL to load a DB2 table using BMC Load Plus JCL.
The job gives a RC of 8 with below message



Part of JCL is job

//STEP1 EXEC PGM=AMUUMAIN,
// PARM='DB0T,XXXXXXXXXXXXX,NEW',
//......
//.......


Error from Job Below

---------------------------------------------------------------------
0: ZIIP NOT ENABLED (115)
ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 8


"'BMC50261E SPACE 'XXXXXX' ALREADY IN USE BY A DB2 UTILITY"


The XXXXXX above is actually the tablespace name. Is there any way to find which DB2 utility is using the tablespace above?

How do we terminate the utility? Please advise.

Re: DB2 LOAD

PostPosted: Mon Mar 17, 2014 5:31 am
by dick scherrer
Hello,

You might try the DIAGNOSE utility. . .

Has DB2 recently been upgraded?