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
 
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 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
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

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