Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us