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
 

 

What is the purpose of DBA reports

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

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Jul 29, 2008 4:42 pm    Post subject: What is the purpose of DBA reports
Reply with quote

I have some questions regarding the reports prepared by DBA for DB2 database. DBA prepares reports like ERROR & EXCEPTION reports for all the DB2 subsystems (development,warehouse,production) & PDASTATS reports (ImageCopy & Extents).

My question is:

1. What is the purpose of each of these reports?
2. By looking at these reports what can be done in the future?
3. How do these reports help to resolve something?
4. What are the other kind of reports that DBA's prepare?
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 Jul 29, 2008 8:23 pm    Post subject:
Reply with quote

Hello and welcome to the forums,

I suggest you talk with your dba(s).

They can tell you exactly what reports they produce and how they use these reports.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Sat Aug 02, 2008 12:20 am    Post subject: Reply to: What is the purpose of DBA reports
Reply with quote

Susanth,

These reports help DBAs get to know on whats going on in the system and what can be done to make the system function better.

e.g. DBAs can generate a report on to enlist all the tablespaces/databases that is not being backed up on a regular basis. Based on the report they would ask application support team to schedule this activity (or make it more frequent, if one exists already).

HTH.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Aug 28, 2008 6:14 pm    Post subject:
Reply with quote

Guyz,

This link will help any doubts regarding the DB2 health check up
http://www.dbazine.com/db2/db2-mfarticles/lyon5
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 Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts Validation of reports generated in As... deb_parthas PL/I & Assembler 3 Wed Jul 30, 2014 3:18 pm
No new posts Multiple sort fields within multiple ... bvarun. DFSORT/ICETOOL 12 Mon Jul 08, 2013 12:21 pm
No new posts SyncSort Reports socker_dad SYNCSORT 9 Mon Oct 29, 2012 7:45 pm
No new posts DFSORT - Summing the Reports HameedAli DFSORT/ICETOOL 6 Sat Oct 13, 2012 2:50 pm


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