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
 

 

DB2 - Load replace by the Job using Plant Util

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Mithun MF

New User


Joined: 09 Sep 2010
Posts: 7
Location: Chennai

PostPosted: Sat Oct 08, 2011 12:09 am    Post subject: DB2 - Load replace by the Job using Plant Util
Reply with quote

I'm facing the below issue on trying to Load replace the table.
I've checked few of the book and no clue about the issue is.

Code:
******* DISPLAY OF DATABASE DPINFC   ENDED      **********************
DSN9022I  -DT1H DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION         
-DISPLAY DATABASE(XXXXX ) SPACENAM(XXXXX ) LOCKS    LIMIT(*)       
                                                                     
PUT0030E - IFI failed, Return Code: 0008   Reason Code: 00E60820       
DSNT360I  -DT1H ***********************************                   
There is another informational message is the job listing. I am not sure of the impact:
DSNT306I  -DT1H RESPONSE MESSAGE LIMIT HAS BEEN REACHED



Below is the command used for the load.

Code:
FASTLOAD
  INPUT-FORMAT     SEQ
  OUTPUT-CONTROL   BUILD
  DISPLAY-STATUS   1000000
  STOP-LIMIT       0010
  RECLUSTER        NO
  DISCARDS         1
  STARTUP-ACCESS   RW
  SPACE-DEFN       NO
  SORTSIZE 6M
  UPDATE-CATSTATS ALL
  RESUME NO REPLACE
  INTO TABLE DATABASE.AB_CD


Does anyone faced this kind of issue? or
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sat Oct 08, 2011 8:11 am    Post subject:
Reply with quote

Mithun,

For this error message,
PUT0030E - IFI failed, Return Code: 0008 Reason Code: 00E60820

You should look at the CA Database Management for DB2 z/OS Message Reference Guide and this was the message,
Code:
PUT0030E - IFI failed, Return Code: &rc
Reason Code: &reas
Reason: DB2 IFI failed.
Action: Use the displayed Return and Reason Codes from DSNWLI (IFI Interface) to diagnose the problem. See the IBM DB2 Messages and Codes manual for code information.


This was taken from DB2 V9 Messages,
Code:
00E60820
Explanation: The command request did not complete normally. Check the IFCABM field in the IFCA to see if any message segments have been returned. There are
many reasons for this condition, including:
v Command authorization failure
v Command processor abend
v Command syntax error
v Command output limit being exceeded.
Problem determination: To determine the reason for the failure, analyze the message or messages that are returned.


You may need to contact your DBA / DB2 System DBA to resolve this issue.

Sushanth
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 Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm


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