DB2 LOAD



IBM's flagship relational database management system

DB2 LOAD

Postby tdanielxyz » Sun Mar 16, 2014 7:16 am

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.
tdanielxyz
 
Posts: 12
Joined: Sun Oct 17, 2010 12:06 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 LOAD

Postby dick scherrer » Mon Mar 17, 2014 5:31 am

Hello,

You might try the DIAGNOSE utility. . .

Has DB2 recently been upgraded?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post