Load Card error



IBM's flagship relational database management system

Load Card error

Postby oksk » Fri Jan 11, 2008 2:30 pm

Hi all,

I'm trying to load a table using BMCLOAD utility. I'm getting the following error:

BMC50135E 'ACTIVE' OPTION HAS CHANGED, BUT IS NOT ALLOWED TO CHANGE ON RESTART OF PHASE = 'PRELOAD' FOR DDTYPE 'LOCPFCPY'
BMC50120E 'IFALLOC' OPTION HAS CHANGED, BUT IS NOT ALLOWED TO CHANGE ON 'RESTART' OF PHASE = 'PRELOAD', USE 'RESTART(PHASE)'

My load card looks like the following:

LOAD DATA REPLACE LOG NO NOCOPYPEND INDDN SYSREC
EBCDIC CCSID(285,65534,65534)
ORDER YES
COPYLVL PART
ACTIVE NO
IFALLOC FREE
INTO TABLE GAOUD5.TCWSCVW_SCV
(SOURCE_SYSTEM POSITION(1:6) CHAR (6)
,CUSTOMER_IDENT POSITION(7:26) CHAR (20)
,GURN POSITION(27:33) DECIMAL
,BRAND_ID POSITION(34:36) CHAR (3)
)

Kindly let me know wat has triggered the error.

Thanks,
OKSK
oksk
 
Posts: 3
Joined: Thu Dec 20, 2007 5:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Load Card error

 

Re: Load Card error

Postby Princeofislands » Sun Aug 24, 2008 5:17 pm

Hi,

I am not sure, if you've got answer for your question or not...The problem could have happened as your previous LOAD attempt(s) would have used some parameters other the current LOAD card's parameters(REPLACE LOG NO NOCOPYPEND INDDN SYSREC )...Your 2nd attempt would have been a normal restart rather than a fresh run.

To overcome this, there will be a UTILID parameter used in your LOAD Job, terminate that UtilID and try the load again..

Cheers,
Princeofislands
Princeofislands
 
Posts: 1
Joined: Sun Aug 24, 2008 4:31 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post