Errors that may occur after patch 7.1.2.6 is installed in DB2 CMO

The following articles mainly describe the error description of connecting Ondemand to sql0206n after installing 7.1.2.6 for DB2 CMO. Our products are: DB2 Content Manager Ondemand for Multiplatform; the operating platform is AIX, Linux, Windows 2000, and Windows NT.

Software Version: 8.3;

Problem description:

After installing patch 7.1.2.6 of IBM DB2 Content Manager Ondemand, The sql0206n error is returned when the Ondemand server is connected. The following error message is displayed in the IBM DB2 Content Manager Ondemand log:

 
 

  
  
DB Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'passwd_exp'. -- SQLSTATE=42S22, SQLCODE=207, File=arsid.c, Line=3107   
  
  
DB Error: [IBM][CLI Driver][DB2/NT] SQL0206N "PASSWD_EXP" is not valid in the context where it is used.  
  
  
SQLSTATE=42703 -- SQLSTATE=42S22, SQLCODE=-206, File=arsid.c, Line=3107 
 
 

How can we solve this problem?

Answer:

In patch 7.1.2.6 of IBM DB2 Content Manager Ondemand, IBM DB2 Content Manager Ondemand provides a method to store default server print parameters for each user. In addition, some independent user management parameters are added, such as password expiration settings and inactive timeout settings. To support these new features, the ARSUSER table must be updated. For existing systems installed with patches and upgrades, you need to use the arsdb command to update the ARSUSER table to use these new features.

In patch 7.1.2.6 of IBM DB2 Content Manager Ondemand, The arsdb command has a new parameter-u, which is used to update the table structure in the database to support the new features. This function updates the table based on the current version number. This command can be executed multiple times but cannot be undone. Therefore, the system administrator should back up the database and recover the database before the operation.

To update a database, perform the following operations:

1. Stop running the IBM DB2 Content Manager Ondemand Server

2. Back up the database and corresponding files of IBM DB2 Content Manager Ondemand

3. Make sure that the current patch is on 7.1.2.6 or later.

4. Run the following command to update the table:

 
 

  
  
arsdb <-I instance_name> -vu  
 
 

5. Restart the IBM DB2 Content Manager Ondemand server.

After installing 7.1.2.6 patch for DB2 CMO, connect Ondemand to get the sql0206n error.