How to get the DB2 server instance owner

31 January,2015 by Jack Vamvas

Getting the DB2 server instance owner is a common requirement for auditing and inventory management. As a DBA, application owners request my team start managing a DB2 server. The first step is to document the DB2 server instance details, such as instance owner, port, data and log file paths,backup schedules,monitoring and a whole host of other details.

To get the DB2 server instance owner is different for Windows and Linux systems.

On Linux the instance owner is the user ID supplied when the db2icrt command was executed.Read more on DB2 database objects.

On Windows systems the DB2 instance owner is the DB2 instance service Run As user ID

DB2 instance owner windows

Read More on DB2 server object management

DB2 Database objects overviews - DBA DB2

How to find the db2 database create date - DBA DB2

Manage DB2 backups retention policy - DBA DB2

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to get the DB2 server instance owner

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright