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
 
Top 20 abends we face in DB2?

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

New User


Joined: 01 Aug 2007
Posts: 1
Location: Mumbai

PostPosted: Fri Sep 07, 2007 8:42 pm    Post subject: Top 20 abends we face in DB2?
Reply with quote

Hi all,

I am new to DB2 could you please provide me some abends that we face quite often. I am looking for list of top 20 abends.

Thanks icon_smile.gif
Back to top
View user's profile Send private message

raviprasath_kp
Warnings : 1

New User


Joined: 20 Feb 2005
Posts: 65
Location: chennai

PostPosted: Fri Sep 07, 2007 9:10 pm    Post subject:
Reply with quote

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNMC0F7/2.1.7?DT=20000424164500
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Sep 07, 2007 9:43 pm    Post subject:
Reply with quote

bryan_lopez,

as you are new to DB2
  • you don't have ABENDs in DB2; SQL failures are reported as negative SQLCODEs
  • there is no top twenty. It all depends on how diligent you are with your syntax and attention to detail


The link that raviprasath_kp gave you is a list of all negative SQLCODEs for vsn 5 of DB2 for OS390. Depending upon the vsn of DB2 and the operating system that is running in your shop, you need to either bookmark or download the appropriate Message and Codes manual for your DB2 vsn. This link displays a list of Messages and Codes for all of IBM's products. i.e. DB2, MQS, CICS, etc....
Back to top
View user's profile Send private message
TG Murphy

Active User


Joined: 23 Mar 2007
Posts: 149
Location: Ottawa Canada

PostPosted: Mon Sep 10, 2007 8:50 pm    Post subject:
Reply with quote

SQLCODE -911 has to be near the top of the list.

deadlocks, timeouts, techniques used to avoid them could fill a book.

SQLCODE -805 ranks up near the top.

We have a document that deals exclusively with all the different situations that can trigger an SQLCODE -805.

Mastering the issues behind -911 and -805 will take you far more time than all the other nasty SQLCODEs combined.

The only abend I can think of is AD2Z which happens when DB2 attempts to issue an automatic SYNCPOINT ROLLBACK in response to SQLCODE -911 while executing in CICS DPL subset. SYNCPOINT ROLLBACK is not allowed in DPL subset...

If your CICS applications don't not issue LINKs to remote regions then you'll never see AD2Z...
Back to top
View user's profile Send private message
md nisar

New User


Joined: 14 Sep 2007
Posts: 2
Location: pune

PostPosted: Mon Sep 17, 2007 4:20 pm    Post subject:
Reply with quote

000 for successfull
100 end of Record or not found
-181 invalid date format
-205 column-name is not a column of table
-305 null indicator required
-313 host variable mismatch
-602 too many columns specified in create index
-805 plan or program not found
-811 cursor not declare or too many rows selected
-818 times stamp mismatch in the load module and bind
-905 unsuccessful execution due to resource limit exceeded,
-911 deadlock with timeout with auto rolled back
-913 deadlock with timeout wih manual rooled back
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 IEFZB476 getting various 0C4 abends Grant Goodale PL/I & Assembler 18 Sat Sep 12, 2015 9:27 pm
No new posts EMPTY FILE - JOB ABENDS d_sarlie JCL & VSAM 4 Fri Jul 25, 2014 1:42 am
No new posts all my abends seemed so far away. Pedro General Talk & Fun Stuff 11 Thu May 01, 2014 12:14 am
No new posts DEFINE PAGESPACE Abends - why? prino JCL & VSAM 3 Tue Apr 24, 2012 10:14 pm
No new posts AEIL/ ASRA abends in CICS Puja Baranwal CICS 3 Mon Feb 27, 2012 5:41 pm

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