Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    Unanswered: Find DB2 job name from system tables.

    Hello Everybody,

    I am basically a Microsoft SQL Server DBA. I am relatively new to DB2 database.

    I would like to know if we can find out the name of the system table in DB2 database, which holds the list of all DB2 jobs that are present on particular DB2 database server. Usually system tables are the ones which are created and maintained internally by the database itself . (This is the concept in Microsoft SQL Server ). Also I would like to know the name of the system table which holds the schedules of jobs like system table msdb..sysjobhistory in MS SQL Server.

    Usually in SQL Server, the list of all jobs is stored in a system table and if we run a SELECT query against the SYSTEM table, it tells the list of all jobs that are present on that SQL Server Instance. That system table name is sysjobs , which is present on the system database named msdb. So for example, it would be SELECT name FROM MSDB..SYSJOBS

    Basically I would like to find out what is the name of the job in DB2 database which runs an UPDATE statement against our table TableA
    Kindly help me in this regard.
    Last edited by db2forumpost; 03-09-10 at 21:42.

  2. #2
    Join Date
    Jan 2010

    you are refering to the scheduler and the jobs in the SQL Server Agent. In DB2 this is done by the Task Center. The scheduling is done by the Admin Server.

    You can check this with
    db2 get admin cfg

    Tools Catalog Database (TOOLSCAT_DB) =
    Tools Catalog Database Instance (TOOLSCAT_INST) =
    Tools Catalog Database Schema (TOOLSCAT_SCHEMA) =
    Scheduler User ID =

    There you can find the Database, the Instance and the Database Schema where tables reside. It's not as easy as in SQL Server to find the Information for each Job, so i'ld recommend to use the Task Center to browse your jobs.

    The link describes how to create a tools catalog:

Posting Permissions

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