Verifying IBM DB2 Permissions for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: IBM DB2 only.

Platforms: UNIX only.

If you are running IBM DB2 on IBM AIX, then perform the following steps before executing the Siebel Database upgrade.

To verify IBM DB2 permissions

  1. Navigate to the instance home directory.

  2. Use the following command to verify that the directory sqllib/function/routine/sqlproc has write permission for the group:

    ls -ld sqllib/function/routine/sqlproc 
    
  3. To authorize group write permission, enter the following command:

    chmod g+w sqllib/function/routine/sqlproc