English
  • PowerCenter 10.1.1
  • All Products

Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Windows
  4. Before You Upgrade the Domain on UNIX
  5. Prepare for the Upgrade
  6. Upgrade the Domain
  7. Upgrade the Domain with Changes to Node Configuration
  8. Before You Upgrade the Application Services
  9. Application Service Upgrade
  10. Informatica Client Upgrade
  11. After You Upgrade
  12. Updating the DynamicSections Parameter of a DB2 Database
  13. Upgrade Checklist

Upgrading from Version 10.0

Upgrading from Version 10.0

Back Next

Verify Database User Account Requirements

Verify Database User Account Requirements

Perform the following tasks for the domain configuration repository database:
  • Set the OPEN_CURSORS parameter to 4000 or higher.
  • Set permissions on the view
    $parameter
     in the Oracle database.
  • Set the privileges to run
    show parameter open_cursors
     in the Oracle database.
    When you run the pre-installation (i10Pi) system check tool, i10Pi runs the command against the database to identify the OPEN_CURSORS parameter with the domain database user credentials.
    You can run the following query to determine the open cursors setting for the domain database user account: 
     SELECT VALUE OPEN_CURSORS FROM V$PARAMETER WHERE UPPER(NAME)=UPPER('OPEN_CURSORS')
  • Set the DynamicSections parameter to 3000 or higher in the IBM DB2 database.
    For more information about updating the DynamicSections parameter, see Updating the DynamicSections Parameter of a DB2 Database.

Updated May 14, 2019

Download Guide
Send Feedback
Explore Informatica Network
Communities
Knowledge Base
Success Portal