Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: Sudden growth in DB2 disk space

    Hi All,

    We have a DB2 database runs on AIX machine. Recently there was unexpected sudden growth for the database at 13th of every month.
    After checking, found that there is no any cron jobs run at that particular day.
    Is it possible to schedule jobs in DB2 (like Oracle job) and what is the command to list out these jobs? Is there any ways to investigate on this issue?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There is the Task Center GUI. It should be on your Windows start menu in the DB2 folder (General Admin Tools). There are special tables and tablespaces used for this with the name "Tools Catalog", "Tools Tablespace", etc. The Tools catalog and tables can be created in the database it controls, or in a separate database to control other databases.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    On windows I use db2tc

    There might be samething on AIX. db2 task center.

    Or from control center select Tool>Task Center

    You should be able to see all scheduled tasks.

    This info can also be obtained by querying ToolsDB database.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by DBFinder
    This info can also be obtained by querying ToolsDB database.
    The tasks may be recorded in a separate ToolsDB database, or the Tools tables could have been created in an existing database.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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