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 Replace repeated JCL with looping REXX prino CLIST & REXX 3 Thu Oct 13, 2016 5:30 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. Sort card to replace text using cross... Susanta SYNCSORT 32 Tue Sep 13, 2016 4:17 pm
No new posts Replace function abdulrafi COBOL Programming 13 Mon Sep 12, 2016 10:12 am


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