Usedb2start parameter for IBM DB2 ESE agent

book

Article ID: 100020872

calendar_today

Updated On:

Resolution

In DB2 version 8, there is no difference to start DB2 in MPP or non-MPP
mode. They all use db2gcf to start database partitions and it won't matter
how many database partitions that you have.

The MPPSupport flag is used to find out which version of DB2 the customer is using (version 7 or 8 and above).

When we start a database partition using "db2gcf -u" command. This command will update the nodename column in db2nodes.cfg after failover with the real host name of the new failover nodes.

Before version 8, the DB2 agent will use "db2start" to start database partition(s). It will leave the db2nodes.cfg file alone and no updates whatsoever during failover. We use "db2gcf" instead of "db2start" to start database because IBM told us that the "db2start" command may not be supported and they plan to deprecate it in the future.

In the new release (5.0MP3+), we add a new Boolean attribute "" to give the customers an option to choose how to start their database. But the way to monitor the database partition will still remain the same.
 

 

Issue/Introduction

Usedb2start parameter for IBM DB2 ESE agent