DB2 daily

[Frank]

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability
Check listener availability
Check alert log files for error messages
Clean up old log files before log destination gets filled
Analyze tables and indexes for better performance
Check tablespace usage
Find out invalid objects
Monitor users and transactions
Thanks for help.

[Anton Versteeg]

See below for possible commands, etc.
Not complete but should get started

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability connect to instname Check listener availability same plus connect to database Check alert log files for error messages grep from db2diag.log Clean up old log files before log destination gets filled what log files are you refering to? transaction (redo) log files? Analyze tables and indexes for better performance reorgchk command Check tablespace usage list tablespaces show detail Find out invalid objects select from syscat.tables (for invalid views)
list packages
etc Monitor users and transactions connect to instance
list applications
or via db2 monitor commands

Thanks for help.

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[Anton Versteeg]

See below for possible commands, etc.
Not complete but should get started

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability connect to instname Check listener availability same plus connect to database Check alert log files for error messages grep from db2diag.log Clean up old log files before log destination gets filled what log files are you refering to? transaction (redo) log files? Analyze tables and indexes for better performance reorgchk command Check tablespace usage list tablespaces show detail Find out invalid objects select from syscat.tables (for invalid views)
list packages
etc Monitor users and transactions connect to instance
list applications
or via db2 monitor commands

Thanks for help.

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[Mark A]

"Anton Versteeg" <an************@nnll.ibm.com> wrote in message
news:c6***********@sp15en20.hursley.ibm.com...

See below for possible commands, etc.
Not complete but should get started

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability

connect to instname

Isn't that "attach to instance"?

[Mark A]

"Anton Versteeg" <an************@nnll.ibm.com> wrote in message
news:c6***********@sp15en20.hursley.ibm.com...

See below for possible commands, etc.
Not complete but should get started

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability

connect to instname

Isn't that "attach to instance"?

[Philip Nelson]

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability
Check listener availability
Check alert log files for error messages
Clean up old log files before log destination gets filled
Analyze tables and indexes for better performance
Check tablespace usage
Find out invalid objects
Monitor users and transactions
Thanks for help.

Before getting into writing anything yourself, I'd suggest you check out the
"Health Center" (assuming you are on V8). It automates a lot of the
mundane monitoring tasks.

HTH

Phil

[Philip Nelson]

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability
Check listener availability
Check alert log files for error messages
Clean up old log files before log destination gets filled
Analyze tables and indexes for better performance
Check tablespace usage
Find out invalid objects
Monitor users and transactions
Thanks for help.

Before getting into writing anything yourself, I'd suggest you check out the
"Health Center" (assuming you are on V8). It automates a lot of the
mundane monitoring tasks.

HTH

Phil

[Blair Adamache]

There is a new article out today that may help you:

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

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability
Check listener availability
Check alert log files for error messages
Clean up old log files before log destination gets filled
Analyze tables and indexes for better performance
Check tablespace usage
Find out invalid objects
Monitor users and transactions
Thanks for help.

[Blair Adamache]

There is a new article out today that may help you:

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

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability
Check listener availability
Check alert log files for error messages
Clean up old log files before log destination gets filled
Analyze tables and indexes for better performance
Check tablespace usage
Find out invalid objects
Monitor users and transactions
Thanks for help.

[Anton Versteeg]

Mark A wrote:

"Anton Versteeg" <an************@nnll.ibm.com> wrote in message
news:c6***********@sp15en20.hursley.ibm.com...

See below for possible commands, etc.
Not complete but should get started

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability

connect to instname

Isn't that "attach to instance"?

yes

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[Anton Versteeg]

Mark A wrote:

"Anton Versteeg" <an************@nnll.ibm.com> wrote in message
news:c6***********@sp15en20.hursley.ibm.com...

See below for possible commands, etc.
Not complete but should get started

Frank wrote:

Coming from Oracle background:

How do you carry thiese admin tasks in DB2 Environment :

Check instance availability

connect to instname

Isn't that "attach to instance"?

yes

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands