Routine tasks

[Frank]

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.

[Blair Adamache]

This will differ highly on how much the database is used, but here are
some starting points for discussion:

daily: log archival, (potentially) incremental backup
weekly: full backup
weeklr or monthly: runstats, reorg

less often than monthly, but likely done before a new fixpak is installed:

- copy database configutation, database manager configuration, settings
of all registry variabbles
- database backup
- db2dart
- inspect (this could also be monthly, since it's online)

Frank wrote:

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.

[Blair Adamache]

This will differ highly on how much the database is used, but here are
some starting points for discussion:

daily: log archival, (potentially) incremental backup
weekly: full backup
weeklr or monthly: runstats, reorg

less often than monthly, but likely done before a new fixpak is installed:

- copy database configutation, database manager configuration, settings
of all registry variabbles
- database backup
- db2dart
- inspect (this could also be monthly, since it's online)

Frank wrote:

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.

[Blair Adamache]

The executable should be under sqllib/bin

Perhaps it only comes with the Appl. Development Client. You can get an
Appl. Development client at the appropriate fixpak level to install
alongside your server here:
ftp://ftp.software.ibm.com/ps/produc.../client/appdev

On Windows, the executable is here:

Directory of C:\Program Files\IBM\SQLLIB\BIN

12/16/2003 08:34p 29,816 enable_MQFunctions.exe
12/16/2003 08:34p 87,168 enable_MQXML.exe
2 File(s) 116,984 bytes
0 Dir(s) 874,471,424 bytes free

C:\tmp>enable_mqfunctions
================================================== ==========
Usage: enable_MQFunctions -n dbName -u uID -p password
[-q queuemanager] [-v 0pc|1pc|2pc|all]
[-novalidate] [-interactive] [-force]
================================================== ==========

Blair Adamache wrote:

This will differ highly on how much the database is used, but here are
some starting points for discussion:

daily: log archival, (potentially) incremental backup
weekly: full backup
weeklr or monthly: runstats, reorg

less often than monthly, but likely done before a new fixpak is installed:

- copy database configutation, database manager configuration, settings
of all registry variabbles
- database backup
- db2dart
- inspect (this could also be monthly, since it's online)

Frank wrote:

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.

[Blair Adamache]

The executable should be under sqllib/bin

Perhaps it only comes with the Appl. Development Client. You can get an
Appl. Development client at the appropriate fixpak level to install
alongside your server here:
ftp://ftp.software.ibm.com/ps/produc.../client/appdev

On Windows, the executable is here:

Directory of C:\Program Files\IBM\SQLLIB\BIN

12/16/2003 08:34p 29,816 enable_MQFunctions.exe
12/16/2003 08:34p 87,168 enable_MQXML.exe
2 File(s) 116,984 bytes
0 Dir(s) 874,471,424 bytes free

C:\tmp>enable_mqfunctions
================================================== ==========
Usage: enable_MQFunctions -n dbName -u uID -p password
[-q queuemanager] [-v 0pc|1pc|2pc|all]
[-novalidate] [-interactive] [-force]
================================================== ==========

Blair Adamache wrote:

This will differ highly on how much the database is used, but here are
some starting points for discussion:

daily: log archival, (potentially) incremental backup
weekly: full backup
weeklr or monthly: runstats, reorg

less often than monthly, but likely done before a new fixpak is installed:

- copy database configutation, database manager configuration, settings
of all registry variabbles
- database backup
- db2dart
- inspect (this could also be monthly, since it's online)

Frank wrote:

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.

[Blair Adamache]

Wow, two days after your posting, someone writes an article about it:

http://www-106.ibm.com/developerwork...now/index.html

Frank wrote:

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.

[Blair Adamache]

Wow, two days after your posting, someone writes an article about it:

http://www-106.ibm.com/developerwork...now/index.html

Frank wrote:

what is your daily , weekly, monthly check list specifically for DB2
on Windows Environment.

Thanks for insight.