The following articles mainly describe the description of sql0206n error after installing 7.1.2.6 patch for DB2 CMO and connecting to Ondemand. After installing 7.1.2.6 patch for DB2 CMO, connect Ondemand to get the description of sql0206n error. I hope it will be helpful in your future study.
Product: DB2 Content Manager Ondemand for Multiplatform;
Platform: AIX, Linux, Windows 2000, 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.
After installing 7.1.2.6 patch for DB2 CMO, connect Ondemand to get the description of sql0206n error. I hope it will help you in this aspect.