IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Unload a table to a DSN - Error DSNU1227I


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
harish_2480

New User


Joined: 07 Jun 2007
Posts: 23
Location: USA

PostPosted: Fri Jun 18, 2010 8:16 pm
Reply with quote

Hi,

I am trying to unload a table from an image copy but getting the error DSNU1227I. I am providing the JCL and spool messages here.

The job:
//DELETE EXEC PGM=IEFBR14
//SYSPRINT DD SYSOUT=A
//DD1 DD DSN=XXXXXX.UNLOAD.TABLEN,DISP=(MOD,DELETE),
// UNIT=DASD,SPACE=(TRK,0)
//DD2 DD DSN=YYYYYY.UNLOAD.PUNCH,DISP=(MOD,DELETE),
// UNIT=DASD,SPACE=(TRK,0)
//*
//UTIL EXEC DSNUPROC,SYSTEM=DSN,UID='RWDL747I' <-UTILID IN IMAGE COPY
//ULDDDN DD DSN=XXXXXX.UNLOAD.TABLEN,DISP=(NEW,CATLG,CATLG),
// UNIT=SYSDA,SPACE=(CYL,(30,100),RLSE),
// DCB=(DSORG=PS,RECFM=FB,LRECL=4096)
//PNHDDN DD DSN=YYYYYY.UNLOAD.PUNCH,DISP=(MOD,CATLG,CATLG),
// UNIT=SYSDA,SPACE=(TRK,(5,5),RLSE)
//SYSIN DD *
UNLOAD TABLESPACE DBNAME.TSNAME
FROMCOPY XXXXXX.XXXXYYYY.RWDL7I10.IMAGECOPY
PUNCHDDN PNHDDN UNLDDN ULDDDN
/*
//*

I am getting the below error messages: (Spool messages)
======================================
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RWDL747I
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - UNLOAD TABLESPACE DBNAME.TSNAME
DSNU650I - DSNUUGMS - FROMCOPY XXXXXX.XXXXYYYY.RWDL7I10.IMAGECOPY PUNCHDDN PNHDD
DSNU1227I DSNUULCB - THE CONTENT OF THE IMAGE COPY DATA SET IS INCONSISTENT WITH TABLE SPACE DBNAME.TSNAME
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

Please help me in this problem and Please do let me know if any other way to unload the table from an image copy to DSN or to a test table. Any JCL or any link is very help full for me.

Thank you & regards,
Harish.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jun 18, 2010 8:52 pm
Reply with quote

Hello,
Code:

DSNU1227I DSNUULCB - THE CONTENT OF THE IMAGE COPY DATA SET IS INCONSISTENT WITH TABLE SPACE DBNAME.TSNAME
This says it all. . .

The imagecopy data is not as you expect.

Suggest you work with the dba to determine your next step.
Back to top
View user's profile Send private message
harish_2480

New User


Joined: 07 Jun 2007
Posts: 23
Location: USA

PostPosted: Fri Jun 18, 2010 9:43 pm
Reply with quote

Hi D.Sch,

Thank you Very much for the help. I will do that and meanwhile i got from my team that there may be a problem with object ID. I will check with DBA and thank you once again.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jun 18, 2010 10:54 pm
Reply with quote

You're welcome - good luck icon_smile.gif

Hopefully, the informational output from the process that created the imagecopy is available. . .

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Error when install DB2 DB2 2
No new posts Pulling a fixed number of records fro... DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
Search our Forums:

Back to Top