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.

Hi,

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:
CREATE TOOLS CATALOG