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

Source: Internet
Author: User
Tags ibm db2

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:

 
 
  1. DB Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'passwd_exp'. -- SQLSTATE=42S22, SQLCODE=207, File=arsid.c, Line=3107   
  2. DB Error: [IBM][CLI Driver][DB2/NT] SQL0206N "PASSWD_EXP" is not valid in the context where it is used.  
  3. 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:

 
 
  1. 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.