Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Unload a table to a DSN - Error DSNU1227I

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Unload a table to a DSN - Error DSNU1227I
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

Site Director


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

PostPosted: Fri Jun 18, 2010 8:52 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Fri Jun 18, 2010 10:54 pm    Post subject: Reply to: Unload a table to a DSN - Error DSNU1227I
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us