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
 

 

Table Lock--SOC1

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

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Tue Feb 28, 2006 1:51 am    Post subject: Table Lock--SOC1
Reply with quote

Guys

this is a real jam for me...
we have a DB2 table on which a column was added. The program using the column is failing repeatedly without giving any message!!
It is a SOC1 abend!!

Anyone help please!!
Back to top
View user's profile Send private message

ranjitbhingare

New User


Joined: 30 Nov 2005
Posts: 94
Location: PUNE

PostPosted: Tue Feb 28, 2006 10:20 am    Post subject:
Reply with quote

Hi,

As per my knowledge we get SOC1 when there is some logical error. I would suggest you to check the logic.

correct me if I am wrong!

Regards,
Ranjit....
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Tue Feb 28, 2006 11:14 am    Post subject: Re: LIFE or DEATh---Table Lock--SOC1????????????
Reply with quote

Hi,
S0C1 will come for many reasons...It may not be occurred because of adding a column to a table. Just verify whether DCLGEN of the table contains this new column definition.

S0C1 explanation is here
S0C1 - OPERATION EXCEPTION - AN OPERATION CODE IS NOT ON THE MACHINE
--POSSIBLE CAUSE--
SUBSCRIPT ERROR - CLOBBERED CODE
TRIED TO READ A FILE THAT WAS NOT OPEN
MISSPELLED DDNAME
ERROR IN PARAMETERS PASSED TO SUBROUTINES
MISSING DD CARD
RECORDING MODE WAS WRONG, OR DENSITY WAS INCORRECT
BAD LOAD MODULE, POSSIBLE BAD OBJECT DECK OR MISSING SUBROUTINE

FORTRAN - MISSING DIMENSION STATEMENT, SAME NAME FOR ARRAY AND A SUBROUTINE

COBOL - SUBROUTINE PROG ID WAS THE SAME AS THE ENTRY NAME COBOL - TRIED TO CALL WITHIN COBOL F SORT INPUT/OUTPUT PROCEDURE
COBOL - TRIED TO CALL A SUBROUTINE WHICH COULD NOT BE FOUND COBOL - INCOMPLETE DCB FOR SORTIN COBOL - USING SORT VERB, DDNAME WAS NOT SORTOUT WHEN THE GIVING OPTION WAS USED. COBOL - EXECUTING SORT-USING AFTER OPENING SORTIN

check whether one of above will match your problem

Thanks
Raghavendra
Back to top
View user's profile Send private message
naive

New User


Joined: 26 Apr 2005
Posts: 46
Location: LA

PostPosted: Tue Feb 28, 2006 2:59 pm    Post subject:
Reply with quote

thanks guys... figured out the problem... memory. program was in vscobol, so run below 24 byte line.The Db2 -IMS load module libraries had been mucked up.Now b2 is OK, but the systems programmer said IMS cant be compiled for a prog in VSCOB3700..
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 how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 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 Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm


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