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 OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm


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