Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: DB2 UDB stored procedures for DBA tasks

    Does anyone know where I can find some good unix scripts for automating basic dba tasks on DB2 UDB using DB2 stored procedures?

    Thanks

    Scott

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    What kind of DBA tasks?

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 UDB stored procedures for DBA tasks

    Have a look at

    http://www.db-hq.net/

    It may be a good starting point , though there are not any stored procedures ....

    Cheers

    Sathyaram

  4. #4
    Join Date
    May 2003
    Posts
    369

    application dba management

    thanks I am looking for a way to troubleshoot errors with stored transform procedures in our qa and prod environments with db2. We dont have an application dba onsite and I need to get up to speed quickly understanding and managing our stored procedures on db2.
    also would be nice for writing stored procedures that monitor tablespace, perform reorgs, performance tuning stored procedures, etc. I know that our sql server dba has written quite a few stored procedures for sql server to do these sorts of dba tasks and would be great to roll out the same for db2 udb.

    thanks.
    scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •