If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Sudden growth in DB2 disk space

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-13-09, 02:49
LLH LLH is offline
Registered User
 
Join Date: Aug 2009
Posts: 1
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?
Reply With Quote
  #2 (permalink)  
Old 08-13-09, 03:23
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
Reply With Quote
  #3 (permalink)  
Old 08-13-09, 14:15
DBFinder DBFinder is offline
Registered User
 
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
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.
Reply With Quote
  #4 (permalink)  
Old 08-13-09, 20:34
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On