Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in


Db2 tools , missing feature , Ideas

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

New User

Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Fri Aug 31, 2012 1:23 pm    Post subject: Db2 tools , missing feature , Ideas
Reply with quote

Hello ,

I need some help to prepare a presentation as a value add to my project .
My question is to get some feedback/inputs from the DBA's who are using either CA/BMC /IBM tools for DB2 . Is there any feature which you can think or have been missing and if implemented could make these tools better in productivity ? Please discuss if you have any idea to make these tools better .

Please share your valuable experience .

Thanks !

Back to top
View user's profile Send private message

sushanth bobby

Senior Member

Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sat Sep 01, 2012 11:50 am    Post subject:
Reply with quote

Hi Carol,

Welcome to IBMMAINFRAMES.com

I think i can give you couple of inputs, i have used CA Platinum suite and some BMC products,

Missing Features, i thought
Tool to identify restrictive statuses of tablespaces in multiple databases and build respective utility statements and in correct order. For example tablespace can be in COPY and Checkpending status at the same time. So, the tool should be intelligent enough to build the check first and copy second. And DBA can decide in the beginning whether to repair all TS with the corresponding repair statements or run corresponding utility on it.

At that time, i was using CA platinum suite in that, Utility Manager/ Object Manger/Database Analyzer did not help. since using Utility Manager we can generate mass utility statements based on the naming conventions not on the restrictive status and Database Analyzer selects tablespaces based on conditions but those were basically for tablespace maintainence purposes. Both these applications reuse the same panels where you select the utility but to fit my scenario, the program should pick the utility based on the restrictive status.

So, since it wasn't available i had to write one in my previous shop, i called it 'DB2OP' icon_biggrin.gif. It saved huge amount of time for me everyday.

CA Detector should have included this feature.
CA Detector is a very good real-time monitoring tool. It could have an additional feature to present information using filter based on a particular correlation id/jobname, plan, package on a particular time period. Currently it just consolidates all the information in a particular pre-set time-bucket(like 6hrs) and we can drill-down from plan-->package-->statements. I thought, since it already has all the required information, why can't it present it in requested specific time, jobname/correlation id, plan/package manner.

Work-around for the above is, ask the app. team to test in a specific time bucket so only that team uses the plans and things like that. If this is not possble, we can use CA-Insight .

Till now Information presented in CA-Insight cannot be saved to a dataset, it would be really nice if that was possible.

Option to ask whether to create Exception Tables or not, when trying build CHECKDATA utility, its missing in both the products CA RC/Query & BMC Catalog Manager.

HDDL in BMC Catalog Manager something similar is not available in RC/Query

In RC/Query, while you are looking for an object, when you give SQL in Command, it will give you SQL which it ran to get the data from DB2 Catalog similar is not available in BMC Catalog Manager.

In ISQL in platinum, you can type an sql statement and type EXPLAIN in command, it will give you the access path details, that is handy, similar is not available in BMC.

That's all i can remember for now.

I hope it was helpful and if any of the above is already available in the tools and i didn't know about it, please let me know. icon_smile.gif

Back to top
View user's profile Send private message
Jimy Carol

New User

Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Mon Sep 03, 2012 1:22 pm    Post subject:
Reply with quote

Thank you very much Sushant for your valuable inputs !!
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 Fault Analyser - missing code explana... egrove IBM Tools 1 Thu Aug 11, 2016 5:55 pm
No new posts Missing Java main class akg Java & MQSeries 3 Wed May 25, 2016 4:05 pm
No new posts “Carriage Return” is missing in f... sudha_be02 JCL & VSAM 1 Mon Feb 15, 2016 5:04 pm
No new posts [SQL0029] INTO clause missing from em... HABBIE DB2 2 Fri Sep 04, 2015 3:54 pm
No new posts Get missing dataset from the concaten... charan_mainframe Mainframe Interview Questions 2 Mon Jun 29, 2015 3:26 pm

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