IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

BMC SQL ERROR ANALYSIS


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
lavishgarg28

New User


Joined: 20 May 2012
Posts: 1
Location: india

PostPosted: Tue Jul 17, 2012 4:28 pm
Reply with quote

Hi,
I want to use BMC to analyse the various errors occurring in region and generate a batch report of these errors.

I can manually check the error codes one by one by going into BMC (4 System and SQL Perf. products >> Q. APPTUNE AND INDEX COMPONENT >> 1. SQL WORKLOAD >> 1. WORKLOAD ANALYSIS) and giving 'E' in front of the DB2 SSID list. This gives the error which have occured in the region.
But it is difficult to check each error code one by one. Is there any batch job or utility that I can use to get the error report in a PS??

I was looking into APPTUNE for DB2® User Guide and got one utility name DOMBCOPY. I think this utility can be used. Please help me if any one has used this utility.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jul 18, 2012 6:13 am
Reply with quote

Hello and welcome to the forum,

Suggest you open an issue with BMC Support - they will know if what you want can be done and if so, how to do it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top