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
 

 

IMS Database Insert Error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Tue Aug 30, 2011 3:24 pm    Post subject: IMS Database Insert Error
Reply with quote

Hi All,

I am getting the following error when i am trying to insert a new segment into the databse.

Code:
+** IGZSAL contains version of IGZERRE dated 25/08/1989. **                     
+** L20456Q9 Region will be treated as COBOL II **  448                         
+TCS0341 - TRCEFILE or LOGSYSIN not defined in region. No trace set.           
+TCS0411 - L20456Q9 is running in a region of 0216K                             
+TCSOCM03 - SETABLE and ANTABLEs built                                         
+DFS0578I - READ SUCCESSFUL FOR DDNAME PROCLIB  MEMBER = IMSLSSM1  IMSL         
+ISRT - STELLA ROOT           STATUS = II       REF    = 019780514             *
         INVALID MESSAGE                                                       
DFS0782I NO INFO ABOUT ABENDING MODULE - R12 NOT POINTING CHANGEID      IMSL   
IEA995I SYMPTOM DUMP OUTPUT  546                                               
  USER COMPLETION CODE=0001                                                     
 TIME=10.50.23  SEQ=08697  CPU=0000  ASID=0060                                 
 PSW AT TIME OF ERROR  078D1000   002B3A08  ILC 2  INTC 0D                     
   ACTIVE LOAD MODULE           ADDRESS=002B06F8  OFFSET=00003310               
   NAME=PRICEPRO                                                               
   DATA AT PSW  002B3A02 - 5810F010  0A0D8000  00010000                         


could you please let me know wat the problem is...??
Back to top
View user's profile Send private message

narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Tue Aug 30, 2011 3:43 pm    Post subject:
Reply with quote

Is it a Duplicate Key Error?????
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Tue Aug 30, 2011 5:25 pm    Post subject:
Reply with quote

Start with your colleagues. See if the output looks "normal" to them for the system you are working on.

Things don't look right about the messages, but I've no idea if that is how they are supposed to look. Let us know.
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: Tue Aug 30, 2011 10:34 pm    Post subject:
Reply with quote

Hello,

Quote:
Is it a Duplicate Key Error?????
Why might you think this?
Because the II indicates a duplicate. . .(Edited)

Quote:
USER COMPLETION CODE=0001
Look in the documentation for the program for the cause of a User 0001. . . Or look in the code itself.
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Aug 31, 2011 1:30 am    Post subject:
Reply with quote

To help you a little bit... IMS returns an II status code when a segment being inserted has a key that matches a key that is already in the database, AND the database is set up to not allow duplicate keys on that segment.

From what you posted, it's probably a key with value "019780514".
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: Wed Aug 31, 2011 2:44 am    Post subject: Reply to: IMS Database Insert Error
Reply with quote

Thanks Ed,

I don't "do" IMS (and did not even note the status), but was hoping to provide a nudge. . . icon_redface.gif

Quote:
Is it a Duplicate Key Error?????
Looks like it is icon_smile.gif

d
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 3:32 pm    Post subject:
Reply with quote

Thanks Dick and Ed.... The problem is now resolved...
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Aug 31, 2011 7:05 pm    Post subject:
Reply with quote

narasimha.g wrote:
Thanks Dick and Ed.... The problem is now resolved...
It'd be nice for us, if you could share the solution you've used.
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 9:18 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
narasimha.g wrote:
Thanks Dick and Ed.... The problem is now resolved...
It'd be nice for us, if you could share the solution you've used.


Ya problem was because of the duplicate key as the database already had the data for some years.... and i had the whole dump of data in my file...

Donno to wat extent its a good programming practice but i just stopped the program from abending for status II as i neither wanted the already existing data to be inserted again nor the program to abend at that record but to continue with the remaining records in the input file.....
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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 IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm


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