Post-conversion tasks for a Db2 pureScale environment

After converting your environment to Db2 pureScale, you must perform several post-conversion tasks to help ensure that your Db2 servers perform at their optimum level.

Procedure

To help ensure that your Db2 servers perform at their optimum level:

  1. If you set the diaglevel database manager configuration parameter to 3 or higher as part of the pre-conversion tasks for a Db2 pureScale environment, reset this parameter to the value that was set before the conversion.

  2. Adjust your database configuration settings to meet new requirements in a Db2 pureScale environment.
    See Adjusting database configuration parameters to meet Db2 pureScale environment requirements for steps that you must take to meet new requirements in a Db2 pureScale environment.
  3. Ensure that the libraries for your external routines remain in the location where they were before the conversion.
    If necessary, restore these libraries from the backup that you performed in Backing up Db2 server configuration and diagnostic information.
  4. Start your database and all necessary database services.
    For details, see Activating a database after upgrade.
  5. If you created local or global file or pipe event monitors in a prior release and the directory or named pipe that you specified is not on a shared file system, drop and re-create them indicating that the directory or named pipe is on a shared file system.
    Otherwise, these event monitors return an error during member failover. For details, see the CREATE EVENT MONITOR statement.
  6. To use the new high availability function in your global event monitors and the default DB2DETAILDEADLOCK event monitor, drop them and re-create them.
    For details, see the CREATE EVENT MONITOR statement.
  7. Back up your databases.
  8. Verify that your environment conversion is successful by connecting to the databases and issuing a small query, as shown in the following example: 
       db2 connect to sample

     Database Connection Information

    Database server        = DB2/AIX64 10.1.0
    SQL authorization ID   = TESTDB2
    Local database alias   = SAMPLE

   db2 select * from syscat.dbauth