473,387 Members | 2,436 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

DB2 daily

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.
Nov 12 '05 #1
10 5296
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

Nov 12 '05 #2
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

Nov 12 '05 #3
"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"?

Nov 12 '05 #4
"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"?

Nov 12 '05 #5
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
Nov 12 '05 #6
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
Nov 12 '05 #7
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.


Nov 12 '05 #8
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.


Nov 12 '05 #9


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

Nov 12 '05 #10


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

Nov 12 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Paddy McCarthy | last post by:
I sent the following this morning: -------- Original Message -------- Subject: Threats to the: Daily Python URL! Date: Mon, 19 Apr 2004 07:50:04 +0100 From: Donald 'Paddy' McCarthy...
0
by: Ray in HK | last post by:
I have 2 tables, they are daily and monthly tables. I want to update the monthly table with the max and min value of the daily table with the corresponding month. I figure out the following...
0
by: Marcel - IDUG Europe 2005 | last post by:
Visit the IDUG Europe Conference Blog for Daily Updates and Conference Information IDUG 2005 - Europe Blog New for this year's conference, IDUG 2005 - Europe has created a blog to give you...
1
by: gbb0330 | last post by:
hi guys -the code (all capital letters) generates daily packing number, it is in the on click event of a command button that moves to the next record. dpkn is unbound control - i use it to...
1
by: guy | last post by:
hi I am looking for Daily calendar control for my ASP.net project. (c#) Where can i download it?? (prefereble ,for free...) The daily calendar or diary suppose to look like the daily task...
2
by: V_S_H_Satish | last post by:
Dear Friends I am working as oracle and ms sql dba from last 4 years. My company recently migrated to DB2 databases. So i am very much new to db2 database Can any one pls provide script to...
0
by: George L. Sexton | last post by:
MH Software, Inc. is pleased to announce the release of version 3.2.11 of its Connect Daily web calendar software. This is primarily a small feature release with a few bug fixes. Topics in this...
6
by: bmjnine | last post by:
Hi all, I am trying to setup a daily task in my .NET (1.1) application. The application is a project management tool, and the daily task I am trying to set up will check for overdue project...
0
by: ambelkar | last post by:
hi, I trying to join weekly & daily tables by using end_dte,Rpt_dte respectively.My week is saturday to friday.first table only having week end' dates but the 2 daily table having daily dates .when...
1
by: naveensrirangam | last post by:
We want to do a total 10 number of scheduled tasks daily. These tasks will run in certain time in daily and every task application developed in different technologies . Now we are looking to do...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.