Thursday, June 14, 2012

Informatica PC 861 Instellation Steps

TABLE OF CONTENTS

12


1  Overview           
2  Download Software       
3  Setup of Database Parameters, Users & Tablespace       
3.1  Database Parameter     
3.2  Repository Account       
3.3  Repository Tablespace 
4  Operating System           
4.1  Processor           
4.2  Temporary Disk Space Requirements    
4.3  UNIX User Account        
4.4  Port Validation 
5  Environment Variables 
5.1  Obtain the locale values               
6  File Descriptor  
7  Installation directory and Permission     
8  Unzip Software
9  Server Software Installation       
10 Domain Tables List          
11 Repository Creation Log          

1           Overview

This document is for informatica administration team, providing the detailed steps on installation of Power Center 8.6.1 on Linux & Oracle Environment.

2           Download Software

 Download Software from informatica Corporation and make sure to get proper keys based on environment (Dev/ Prod).

3           Setup of Database Parameters, Users & Tablespace

 

3.1            Database Parameter

Set the open_cursors parameter to 1000
SQL> SHOW parameter open_cursor;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300
SQL> ALTER system SET open_cursors=1000;

System altered.

SQL>  ALTER system SET open_cursors=1000 SCOPE=BOTH;

System altered.

SQL> SHOW parameter open_cursors;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     1000

3.2            Repository Account

At least two database user accounts (Domain and Repository) are required to host repository, Taking sample names as
USER_REP for the repository Database
USER_DOM for the domain Configuration Database
Both user need to create with the CONNECT, RESOURCE, and CREATE VIEW privileges.
For Oracle, you must perform the following instruction:
CREATE USER UAER_REP IDENTIFIED BY USER_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW TO USER_REP;

CREATE USER UASER_DOM IDENTIFIED BY USER_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW, SELECT ANY dictionary TO USER_DOM;

The grant “select dictionary privilege” to the user INFA_DOM is only needed to verify the parameter Open_Cursor during the prerequisite check.
  
3.3            Repository Tablespace

Set the storage size for the tablespace to a small number to prevent the repository from using an excessive amount of space.
Also verify that the default tablespace for the user that owns the repository tables is set to a small size. The following example shows how to set the recommended storage parameter for a tablespace named PC_TABLESPACE.
ALTER TABLESPACE "PC_TABLESPACE" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED PCTINCREASE 50 );

 4           Operating System
 4.1            Processor

Verify that the process match the software (x86_64)
Display the Linux platform =  uname - p
List the basic system information, OS release, and OS version  = uname -orv
-bash-3.2$ uname -p
x86_64

-bash-3.2$ uname –arv

Linux ServerName 2.6.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
  
4.2            Temporary Disk Space Requirements

The installer writes temporary files to the hard disk. When the installation completes, the installer deletes the temporary files and releases the disk space.
Installer UNIX
1 GB
Informatica Services UNIX
2 GB
Verification of the temporary space with the df
-bash-3.2$  df -h /tmp
  
4.3            UNIX User Account

On UNIX, create a user account -bash-3.2$ specifically to run the Informatica daemon required for installation having group privileges’ on Oracle and java groups

4.4            Port Validation

Verify that the port numbers are available on the machines where you install Informatica Services.
-bash-3.2$  netstat -tulpn|grep 6005
The installer validates the port numbers that you specify to ensure that there will be no port conflicts in the domain.
-bash-3.2$  netstat -tulpn|grep 6001
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
tcp        0      0 :::6001                     :::*                        LISTEN      4935/java
-bash-3.2$  netstat -tulpn|grep 6002
(Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.)
tcp        0      0 ::ffff:127.0.0.1:6002       :::*                        LISTEN      4935/java
-bash-3.2$  netstat -tulpn|grep 6003
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
-bash-3.2$  netstat -tulpn|grep 6004
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)

5           Environment Variables

Most UNIX systems use the LANG variable to specify the desired locale but you can use also the set locale function.

5.1            Obtain the locale values

To obtain the locale names for your UNIX system, enter the following:
infa@chetltst201 $ locale -a | grep -i en
en_AU
en_AU.iso88591
en_AU.utf8
en_BW
en_BW.iso88591
en_BW.utf8
en_CA
en_CA.iso88591
en_CA.utf8
en_DK
en_DK.iso88591
en_DK.utf8
en_GB
en_GB.iso88591
en_GB.iso885915
en_GB.utf8
en_HK
en_HK.iso88591
en_HK.utf8
en_IE

6           File Descriptor

Informatica service processes can use a large number of files. Set the Linux - File Descriptor limit per process to 3000 or higher.
In the file /etc/security/limits.conf, add this line:
# PowerCenter
-bash-3.2$   hard   nofile    3001
-bash-3.2$   soft   nofile    2500
And verify with the ulimit function logged as the powercenter system user account:
-bash-3.2$  ulimit -Hn
3001
The limit is set to 3001 to prevent an error with the value 300 during the prerequisites check ;-)

7           Installation directory and Permission

As root, create the installation base directory:
Pwd
/infa
mkdir /informatica
chown  755 informatica
cd informatica
mkdir pc86
chown 755 pc86
cd  /infa
mkdir software
chmod 755 software

 8           Unzip Software

-rw-r--r-- 1 -bash-3.2$ infadmin  880824320 May 21 18:30 pc861_linux_em64t.tar
-rw-r--r-- 1 -bash-3.2$ infadmin 1219901440 May 21 18:30 pc861_HotFix14_linux_em64t.tar

-bash-3.2$@ServerName $ tar -xf pc861_linux_em64t.tar
-bash-3.2$@ServerName $ ls -ltr

drwxr-xr-x 3 -bash-3.2$ infadmin       4096 Nov 17  2008 Update
-rwxr-xr-x 1 -bash-3.2$ infadmin       4169 Nov 17  2008 jpsjis.msg
-rwxr-xr-x 1 -bash-3.2$ infadmin       4347 Nov 17  2008 english.msg
drwxr-xr-x 4 -bash-3.2$ infadmin       4096 Dec  1  2008 sapsolutions
drwxr-xr-x 4 -bash-3.2$ infadmin       4096 Dec  1  2008 saptrans
-rwxr-xr-x 1 -bash-3.2$ infadmin       4378 Dec  5  2008 ko_euckr.msg
-rwxr-xr-x 1 -bash-3.2$ infadmin       3451 Dec  5  2008 zh_gbk.msg
-rwxr-xr-x 1 -bash-3.2$ infadmin       3640 Dec 12  2008 jpeuc.msg
drwxr-xr-x 3 -bash-3.2$ infadmin       4096 Dec 19  2008 Server
-rwxr-xr-x 1 -bash-3.2$ infadmin      10364 Dec 19  2008 install.sh
-rwxr-xr-x 1 -bash-3.2$ infadmin        343 Dec 19  2008 infa_install_version.properties
-rw-r--r-- 1 -bash-3.2$ infadmin  880824320 May 21 18:30 pc861_linux_em64t.tar
-rw-r--r-- 1 -bash-3.2$ infadmin 1219901440 May 21 18:30 pc861_HotFix14_linux_em64t.tar

9           Server Software Installation


-bash-3.2$@ServerName $ ./install.sh

\***************************************************************************
\* Welcome to the Informatica PowerCenter 8.6.1 Installer.  *
\***************************************************************************

\Before you continue, read the PowerCenter Installation Guide and Release Notes.
You can find the PowerCenter documentation in the Documentation Center at http://my.informatica.com
Do you want to continue? (Y/N)Y
Installer requires operating system Linux version 2.4 and later.
Current operating system Linux version 2.6.
Current operating system meets minimum requirements.
-----------------------------------------------------------
Checking for existing PowerCenter product installation.
Unset the INFA_HOME,INFA_NODE_NAME and INFA_DOMAINS_FILE before continuing
the installation. Continuing the installation with the environment variables set
will cause the installation to fail.
Installer will exit now.
-bash-3.2$@ServerName $ unset INFA_HOME
-bash-3.2$@ServerName $ unset INFA_NODE_NAME
-bash-3.2$@ServerName $ unset INFA_DOMAINS_FILE

-bash-3.2$@ServerName $ ./install.sh

\***************************************************************************
\* Welcome to the Informatica PowerCenter 8.6.1 Installer.  *
\***************************************************************************

\Before you continue, read the PowerCenter Installation Guide and Release Notes.
You can find the PowerCenter documentation in the Documentation Center at http://my.informatica.com
Do you want to continue? (Y/N)Y
Installer requires operating system Linux version 2.4 and later.
Current operating system Linux version 2.6.
Current operating system meets minimum requirements.
-----------------------------------------------------------
Checking for existing PowerCenter product installation.
Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):C
Launching installer in console mode ...
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Preparing CONSOLE Mode Installation...
===============================================================================
Choose Locale...
----------------------------------------------------------------------------------------------------------------------------------
  ->1- English
CHOOSE LOCALE BY NUMBER: 1
===============================================================================
PowerCenter 8.6.1                 (created with InstallAnywhere by Macrovision)
---------------------------------------------------------------------------------------------------------------------------------
 
===============================================================================
Welcome
----------------------------------------------------------------------------------------------------------------------------------
Welcome to Informatica PowerCenter 8.6.1.
Use this wizard to install Informatica PowerCenter 8.6.1.
Copyright 1998-2008 Informatica Corporation. All rights reserved.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Configure Environment Variables
----------------------------------------------------------------------------------------------------------------------------------
Required UNIX Environment Variables, You must set the following environment variables to continue with the installation on UNIX machines:
DISPLAY variable: Configure the DISPLAY variable to run the GUI-based installation program using X Windows on Solaris, AIX, HP-UX, and Linux.

Locale variables: Configure the LANG, LANG_C, LC_TYPE, and LC_ALL variables to generate appropriate code pages and create and connect to repositories and Repository Services.

If any of the required variables are not configured, quit the installation program, configure the variables, and restart the installation program. If you are not sure that the environment is correctly configured, quit the installation and verify environment settings. For more information about configuring environment variables and testing database connections, see the PowerCenter Installation Guide.

PRESS <ENTER> TO CONTINUE:
===============================================================================
Choose Installation Type
-----------------------------------------------------------------------------------------------------------------------------------------
Please choose the Install Set to be installed by this installer.
  ->1- Install PowerCenter 8.6.1
    2- Upgrade to PowerCenter 8.6.1
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
   : 1
===============================================================================
PowerCenter License Key
----------------------------------------------------------------------------------------------------------------------------------------
<Type 'back' for the previous panel or 'quit' to exit the installer.>
License key file
Select the license key file: (DEFAULT: /home/-bash-3.2$/license.key):
/infa/informatica/pc86/LicenceKey_Lin64_V861.key
===============================================================================
Installation Prerequisites
----------------------------------------------------------------------------------------------------------------------------------------
Verify the installation prerequisites and complete the pre-installation tasks before continuing with the installation.

Prerequisites

Domain Configuration Database
- Oracle, Microsoft SQL Server, Sybase ASE, or IBM DB2
- At least one database user account is required to complete the installation.

Disk Space Requirements
- 2 GB

Pre-installation Tasks

Create a system user account and configure the web browser for the PowerCenter Administration Console, Metadata Manager & Business Glossary, and Data Analyzer applications. Determine the port numbers to use for nodes in the domain. Optionally, configure environment variables and set up a keystore file for HTTPS support. For more information, see the PowerCenter Installation Guide.

PRESS <ENTER> TO CONTINUE:
===============================================================================
Installation Directory
----------------------------------------------------------------------------------------------------------------------------------
<Type 'back' for previous screen and 'quit' to exit installer>
Choose the installation directory:
 Default Install Folder: /home/-bash-3.2$/Informatica/PowerCenter8.6.1
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
      : /infa/informatica/pc86

INSTALL FOLDER IS: /infa/informatica/pc86
   IS THIS CORRECT? (Y/N): Y
===============================================================================
PowerCenter HTTPS Configuration
-----------------------------------------------------------------------------------------------------------------------------------
    1- Do not enable https
  ->2- Use a keystore generated by the installer
    3- Use existing keystore file
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
   : 2
===============================================================================
PowerCenter HTTPS Configuration
-----------------------------------------------------------------------------------------------------------------------------------
HTTPS Port Number: (DEFAULT: 8443): 8443
===============================================================================
Pre-Installation Summary
-----------------------------------------------------------------------------------------------------------------------------------
Review the following information before continuing. Enter 'Back' to go back and change settings.
Product Name: PowerCenter 8.6.1
Install Folder:   /infa/informatica/pc86
Disk Space Requirements
Required Space :
    1,386 MB
Available Space :
    77,604 MB
HTTPS status
    HTTPS enabled

PRESS <ENTER> TO CONTINUE:
===============================================================================
Installing...
-----------------------------------------------------------------------------------------------------------------------------------
 [==================|==================|==================|==================]
 [------------------|------------------|------------------|------------------]
 
===============================================================================
Create or Join Domain
-----------------------------------------------------------------------------------------------------------------------------------
<Type 'back' for the previous panel or 'quit' to exit the installer.>
For more information about creating or joining a domain, see the PowerCenter Installation Guide.

Note: PowerCenter is licensed on a CPU basis. Consult your licensing agreement for details about your licensed configuration.

  ->1- Create New Domain (If you are installing PowerCenter for the first time or you want to create a new domain.)
    2- Join Existing Domain (If you are installing PowerCenter on multiple machines and you already created a domain on another machine.)

Enter an option:: <Default:1>: 1
===============================================================================
Configure Domain Database
-----------------------------------------------------------------------------------------------------------------------------------
<Type 'back' for the previous panel or 'quit' to exit the installer.>

Enter the account information for the database to store PowerCenter domain configuration metadata. Each PowerCenter domain must store configuration metadata in a separate database account.

  ->1- Oracle
    2- DB2
    3- SQLServer
    4- Sybase

Database type:: <Default:1>: 1

  ->1- Default
    2- Custom string

Database URL type:: <Default:1>: 2

Database user ID:: USER_DOM
Database user password::
Custom string: (DEFAULT: jdbc:informatica:databasetype://hostname:portno....): :jdbc:informatica:Oracle://11.22.333.111:1521;SID=pc86

===============================================================================
Configure Domain
----------------------------------------------------------------------------------------------------------------------------------
<Type 'back' for the previous panel or 'quit' to exit the installer.>
Enter the information for the PowerCenter domain to create.

Domain name: (DEFAULT: Domain_ServerName): domain_abc_dev
Domain host name: (DEFAULT: ServerName): servername
Node name: (DEFAULT: node01_ServerName): node1_abc_dev
Domain port no: (DEFAULT: 6001): 6001
Domain user name: (DEFAULT: admin): Administrator
Domain password:: Administrator
Confirm password:: Administrator

Configure minimum and maximum port numbers? (Y/N) (DEFAULT: N)

===============================================================================
Post-Installation Summary
----------------------------------------------------------------------------------------------------------------------------------
Installation Status : SUCCESS

The PowerCenter 8.6.1 installation completed successfully. The information
below summarizes the location of the installed products .

For more information, see the debug log file at
/infa/informatica/pc86/Informatica_Installation_Server_Debug.log

Product Name :
------------------------
PowerCenter 8.6.1

Components :
------------------------
PowerCenter Services
PowerCenter Data Analyzer
PowerCenter Metadata Manager Business Glossary

Installation Directory :
------------------------
/infa/informatica/pc86

PowerCenter Services Configuration

PRESS <ENTER> TO CONTINUE:

--------------------------------------------
Administration Console URL : http://ServerName:6001/adminconsole
Domain Name : domain_abc_dev
 Gateway Host Name : ServerName
Administrator User Name : Administrator
Node Name : node1_abc_dev
Node Port Number : 6001
  
10       Domain Tables List


PCSF_CPU_USAGE_SUMMARY                          TABLE    
PCSF_DOMAIN                                                     TABLE    
PCSF_DOMAIN_GROUP_PRIVILEGE                  TABLE    
PCSF_DOMAIN_USER_PRIVILEGE                      TABLE    
PCSF_GROUP                                                        TABLE    
PCSF_MASTER_ELECTION                                   TABLE    
PCSF_MASTER_ELECT_LOCK                              TABLE    
PCSF_REPO_USAGE_SUMMARY                        TABLE    
PCSF_ROLE                                                            TABLE    
PCSF_RUN_LOG                                                   TABLE    
PCSF_SOURCE_AND_TARGET_USAGE              TABLE    
PCSF_USER                                                            TABLE    

 11       Repo Creation Log

Create Contents operation on repository [REPO_DEV_ABC] started at 05/21/2012 19:08:30.
DROP TABLE OPB_REPOSIT
DROP TABLE OPB_SUBJECT
DROP TABLE OPB_PICDSC
DROP TABLE OPB_SRC_FLD
DROP TABLE OPB_SCHEMA
DROP TABLE OPB_SRC
DROP TABLE OPB_SELINFO
DROP TABLE OPB_TARG
DROP TABLE OPB_TARG_FLD
DROP TABLE OPB_FLDLINK
DROP TABLE OPB_TARGINDEX
DROP TABLE OPB_TARGINDEXFLD
DROP TABLE OPB_RTSEQ
DROP TABLE OPB_DBD
DROP TABLE OPB_LOAD_SESSION
DROP TABLE OPB_LOAD_FILES
DROP TABLE OPB_BATCH_SESSION
DROP TABLE OPB_LOAD_BATCH
DROP TABLE OPB_BATCH_OBJECT
DROP TABLE OPB_DATABASES
DROP TABLE OPB_LOAD_SESS_CMDS
DROP TABLE OPB_SESSION_LOG
DROP TABLE OPB_SESS_TARG_LOG
DROP TABLE OPB_RECOVERY
DROP TABLE OPB_KEYWORD
DROP TABLE OPB_SESSION_PARAMS
DROP TABLE OPB_CC_INSTANCE
DROP TABLE OPB_CC_MAPPINGS
DROP TABLE OPB_CC_SRC_TBLS
DROP TABLE OPB_CC_REF_TABLES
DROP TABLE OPB_CC_SRCDB_ATTR
DROP TABLE OPB_TARGET_OPT
DROP TABLE OPB_SOURCE_OPT
DROP TABLE OPB_TARG_TEMP
DROP TABLE OPB_TARGFLD_TEMP
DROP TABLE OPB_FLDLINK_TEMP
DROP TABLE OPB_LOADSEQ_TEMP
DROP TABLE OPB_DEFERRED_TASKS
DROP TABLE OPB_MAPPING
DROP TABLE OPB_DBDS
DROP TABLE OPB_TDS
DROP TABLE OPB_WIDGET_DEP
DROP TABLE OPB_WIDGET
DROP TABLE OPB_WIDGET_EXPR
DROP TABLE OPB_EXPRESSION
DROP TABLE OPB_WIDGET_INST
DROP TABLE OPB_MAP_TARG_INFO
DROP TABLE OPB_WIDGET_FIELD
DROP TABLE OPB_OBJECT_TYPE
DROP TABLE OPB_ATTR
DROP TABLE OPB_WIDGET_ATTR
DROP TABLE OPB_MAP_OPTIONS
DROP TABLE OPB_USERS
DROP TABLE OPB_GROUPS
DROP TABLE OPB_USER_GROUPS
DROP TABLE OPB_USER_GROUP
DROP TABLE OPB_ROLE
DROP TABLE OPB_OBJECT_ACCESS
DROP TABLE OPB_REPOSIT_INFO
DROP TABLE OPB_SHORTCUT
DROP TABLE OPB_NORM_FLD
DROP TABLE OPB_SERVER_INFO
DROP TABLE OPB_OBJECT_LOCKS
DROP TABLE OPB_REPOSIT_LOG
DROP TABLE OPB_GEN_OBJECT
DROP TABLE OPB_GEN_OBJ_REFS
DROP TABLE OPB_MD_HIER_GRAPH
DROP TABLE OPB_MD_FACT_FIELD
DROP TABLE OPB_MD_LEVEL_FIELD
DROP TABLE OPB_MD_CUBE_FIELD
DROP TABLE OPB_MD_LVL_HRCHY
DROP TABLE OPB_MD_FACT_LEVEL
DROP TABLE OPB_MD_CUBE_HRCHY
DROP TABLE OPB_MD_HIERARCHY
DROP TABLE OPB_MD_FACT
DROP TABLE OPB_MD_LEVEL
DROP TABLE OPB_MD_DIMENSION
DROP TABLE OPB_MD_CUBE
DROP TABLE OPB_SCHEMA_IDS
DROP TABLE OPB_SCHEMA_DEPLOY
DROP TABLE OPB_SRV_LOC_VARS
DROP TABLE OPB_WIDGET_INIT
DROP TABLE OPB_WIDG_FLD_ATTR
DROP TABLE OPB_PROGRAM_INFO
DROP TABLE OPB_LOAD_MAPPING
DROP TABLE OPB_LOAD_DBDS
DROP TABLE OPB_LOAD_SDS
DROP TABLE OPB_LOAD_TDS
DROP TABLE OPB_LOAD_OPTIONS
DROP TABLE OPB_FLD_MAPPING
DROP TABLE OPB_LOAD_FLD_SCRUB
DROP TABLE OPB_LOAD_TBL_SCRUB
DROP TABLE OPB_SQL_OVERRIDE
DROP TABLE OPB_LOAD_SEQ
DROP TABLE OPB_SRC_TBL_INFO
DROP TABLE OPB_SPS
DROP TABLE OPB_LOAD_SPS
DROP TABLE OPB_DBD_TEMP
DROP TABLE OPB_SRC_TEMP
DROP TABLE OPB_SRCFLD_TEMP
DROP TABLE OPB_PICDSC_TEMP
DROP TABLE OPB_INDEX_TEMP
DROP TABLE OPB_INDEXFLD_TEMP
DROP TABLE OPB_WIDGET_TEMP
DROP TABLE OPB_EXPR_TEMP
DROP TABLE OPB_SELINFO_TEMP
DROP TABLE OPB_MAPPING_TEMP
DROP TABLE OPB_KEYWORD_TEMP
DROP TABLE OPB_ANALYZE_DEP
DROP TABLE OPB_SESS_DSQ
DROP TABLE OPB_SS_TEMP
DROP TABLE OPB_TARG_FLD_EXPR
DROP TABLE OPB_TARG_TBL_EXPR
DROP TABLE OPB_SS_SCHEMA
DROP TABLE OPB_SS_TABLES
DROP TABLE OPB_SS_RELATIONS
DROP TABLE OPB_SS_DIMENSIONS
DROP TABLE OPB_BCF_TREE
DROP TABLE OPB_BCF_BUSCOMPS
DROP TABLE OPB_SESS_WIDG_INST
DROP TABLE OPB_TABLE_GROUP
DROP TABLE OPB_XML_INFO
DROP TABLE OPB_SAP_FUNC
DROP TABLE OPB_SAP_FUNC_PARAM
DROP TABLE OPB_SAP_STRUCT
DROP TABLE OPB_SAP_STRUCT_FLD
DROP TABLE OPB_SAP_FUNC_INST
DROP TABLE OPB_SAP_DSQ_OPRT
DROP TABLE OPB_SAP_FUNC_VARS
DROP TABLE OPB_SAP_CODEBLK
DROP TABLE OPB_SAP_PGMFLOW
DROP TABLE OPB_PARTITION
DROP TABLE OPB_SESS_PARMVAR
DROP TABLE OPB_MAP_PERVAL
DROP TABLE OPB_MAP_PARMVAR
DROP TABLE OPB_SEBL_MVL_LREL
DROP TABLE OPB_SEBL_MVL_ATTR
DROP TABLE OPB_SEBL_JOIN_ATTR
DROP TABLE OPB_SEBL_LINK
DROP TABLE OPB_SEBL_LINKX
DROP TABLE OPB_MMD_DOMAIN
DROP TABLE OPB_MMD_METAEXT
DROP TABLE OPB_METAEXT_VAL
DROP TABLE OPB_TASK
DROP TABLE OPB_TASK_INST
DROP TABLE OPB_TASK_ATTR
DROP TABLE OPB_WORKFLOW
DROP TABLE OPB_WFLOW_DEP
DROP TABLE OPB_WFLOW_EXPR
DROP TABLE OPB_WFLOW_VAR
DROP TABLE OPB_WFLOW_PERVAL
DROP TABLE OPB_EVENT
DROP TABLE OPB_SCHEDULER
DROP TABLE OPB_SCHEDULE_LOGIC
DROP TABLE OPB_SESSION
DROP TABLE OPB_SESSION_CONFIG
DROP TABLE OPB_CFG_ATTR
DROP TABLE OPB_COMPONENT
DROP TABLE OPB_SWIDGET_INST
DROP TABLE OPB_EXTN_ATTR
DROP TABLE OPB_CNX
DROP TABLE OPB_CNX_ATTR
DROP TABLE OPB_SESS_CNX_REFS
DROP TABLE OPB_SESS_EXTNS
DROP TABLE OPB_SESS_FILE_REF
DROP TABLE OPB_FILE_DESC
DROP TABLE OPB_PARTITION_DEF
DROP TABLE OPB_KEY_RANGE
DROP TABLE OPB_MMD_TASK_ATTR
DROP TABLE OPB_MMD_TATTR_VAL
DROP TABLE OPB_MMD_CFG_ATTR
DROP TABLE OPB_MMD_CFGAT_VAL
DROP TABLE OPB_MMD_SESS_EXTNS
DROP TABLE OPB_MMD_LIBS
DROP TABLE OPB_MMD_EXTN_ATTR
DROP TABLE OPB_MMD_EATTR_VAL
DROP TABLE OPB_MMD_DBTYP2EXTN
DROP TABLE OPB_MMD_EXTN_CNXN
DROP TABLE OPB_MMD_ECNXN_REF
DROP TABLE OPB_MMD_CNX
DROP TABLE OPB_MMD_CNX_ATTR
DROP TABLE OPB_MMD_CATTR_VAL
DROP TABLE OPB_MMD_CATALOG
DROP TABLE OPB_MMD_PLGCOMP
DROP TABLE OPB_MMD_DBTYPE
DROP TABLE OPB_MMD_DBSUBTYPE
DROP TABLE OPB_MMD_KEYTYPE
DROP TABLE OPB_MMD_DATATYPE
DROP TABLE OPB_MMD_FLDATTR
DROP TABLE OPB_SESS_TASK_LOG
DROP TABLE OPB_SWIDGINST_LOG
DROP TABLE OPB_WFLOW_RUN
DROP TABLE OPB_TASK_INST_RUN
DROP TABLE OPB_WFLOW_VAR_RUN
DROP TABLE OPB_WFLOW_DEP_RUN
DROP TABLE OPB_WFLOW_CACHE
DROP TABLE OPB_MAP_PERSISVAL
DROP TABLE OPB_MMD_EXTN_WATTR
DROP TABLE OPB_TASK_VAL_LIST
DROP TABLE OPB_HASH_KEY
DROP TABLE OPB_MMD_CATTR2EXTN
DROP TABLE OPB_MMD_EATTR2CNX
DROP TABLE OPB_MMD_EXTN_FILE
DROP TABLE OPB_SESS_CNX_VALS
DROP TABLE OPB_SESS_FILE_VALS
DROP TABLE OPB_SESS_PER_FILES
DROP TABLE OPB_UPGRADE_HIST
DROP TABLE OPB_DTL_SWIDG_LOG
DROP TABLE OPB_REPO_PARAM
DROP TABLE OPB_VERSION_PROPS
DROP TABLE OPB_CM_QUERY
DROP TABLE OPB_CM_QUERY_PARAM
DROP TABLE OPB_CM_LABEL
DROP TABLE OPB_CM_LABEL_REF
DROP TABLE OPB_CM_DEPLOY
DROP TABLE OPB_CM_DEPLOY_REF
DROP TABLE OPB_CM_DEPLOY_LOG
DROP TABLE OPB_CM_DEPDETAIL
DROP TABLE OPB_SERVER_NET
DROP TABLE OPB_SERVER_NET_REF
DROP TABLE OPB_WFLD_ATTR
DROP TABLE OPB_WFLD_ATTR_DEF
DROP TABLE OPB_WFLD_INOUTDEP
DROP TABLE OPB_SWIDG_GROUP
DROP TABLE OPB_VALIDATE
DROP TABLE OPB_XML_QUAL
DROP TABLE OPB_PROF_RULESET
DROP TABLE OPB_PROF_METADATA
DROP TABLE OPB_PROF_SRC_REF
DROP TABLE OPB_MMD_TEMPLATE
DROP TABLE OPB_MMD_TMPL_ATTR
DROP TABLE OPB_MMD_TMPL2EXTN
DROP TABLE OPB_ATTR_CATEGORY
DROP TABLE UPGRADE_STATE
DROP TABLE OPB_PROF_RESOURCE
DROP TABLE OPB_PROF_RES_DATA
DROP TABLE OPB_PROF_RES_REF
DROP TABLE OPB_MMD_DBTY2WATTR
DROP TABLE OPB_MMD_DBTY2WAVAL
DROP TABLE OPB_TASK_STATS
DROP TABLE OPB_SERVICE_LEVEL
DROP TABLE OPB_SLEVEL_ATTR
DROP TABLE OPB_MMD_SLVL_ATTR
DROP TABLE OPB_MMD_FUNC_GRP
DROP TABLE OPB_MMD_FUNCTION
DROP TABLE OPB_MACRO
DROP TABLE OPB_MACRO_EXPR
DROP TABLE OPB_MACRO_ARGS
DROP TABLE OPB_MACRO_REF
DROP TABLE OPB_WIDG_MCR_DEP
DROP TABLE OPB_LINK_MCR_DEP
DROP TABLE OPB_TASK_MCR_DEP
DROP TABLE OPB_TASK_RES_REFS
DROP TABLE OPB_OPB_OBJECT_LOCKS
DROP TABLE OPB_SERVICED_REQ
DROP TABLE OPB_CLIENT_CONN
DROP TABLE OPB_REQ_AUX
DROP TABLE OPB_WFLOW_RUN_BRK
DROP TABLE OPB_TASK_INST_BRK
DROP TABLE OPB_REQ_REPLY
DROP TABLE OPB_REQ_AUX
DROP TABLE OPB_PROXYUSER_INFO
DROP TABLE OPB_NOTIF_MSG
DROP TABLE OPB_OBJECT_NOTIF
DROP TABLE OPB_SERVER_NODE
DROP TABLE OPB_PERF_COUNT
DROP TABLE OPB_SWIDGET_ATTR
DROP TABLE OPB_WF_RUNINFO
DROP VIEW REP_SEG_FLDS
DROP VIEW REP_SRC_FILE_FLDS
DROP VIEW REP_SRC_TBL_FLDS
DROP VIEW REP_DATABASE_DEFS
DROP VIEW REP_SRC_FILES
DROP VIEW REP_SRC_TBLS
DROP VIEW REP_TBL_MAPPING
DROP VIEW REP_FLD_MAPPING
DROP VIEW REP_SCHEMA
DROP VIEW REP_TARG_TBLS
DROP VIEW REP_TARG_TBL_COLS
DROP VIEW REP_TARG_MAPPING
DROP VIEW REP_TARG_FLD_MAP
DROP VIEW REP_SRC_MAPPING
DROP VIEW REP_SRC_FLD_MAP
DROP VIEW REP_TARG_TBL_JOINS
DROP VIEW REP_WORKFLOWS
DROP VIEW REP_LOAD_SESSIONS
DROP VIEW REP_SESSION_CNXS
DROP VIEW REP_SESSION_INSTANCES
DROP VIEW REP_SESS_LOG
DROP VIEW REP_SESS_TBL_LOG
DROP VIEW REP_SSCHEMA
DROP VIEW REP_SSCHEMA_TBLS
DROP VIEW REP_SSCHEMA_CARD
DROP VIEW REP_SESSION_FILES
DROP VIEW REP_SESSION_INST_FILES
DROP TABLE REP_PIC_USAGE
DROP TABLE REP_FLD_DATATYPE
DROP TABLE REP_SRC_KEY_TYPES
DROP TABLE REP_TARG_KEY_TYPES
DROP TABLE REP_DB_TYPES
DROP TABLE REP_CARD_TYPE
DROP TABLE REP_TARG_TYPE
DROP VIEW REP_ALL_SOURCES
DROP VIEW REP_ALL_SOURCE_FLDS
DROP VIEW REP_ALL_TARGETS
DROP VIEW REP_ALL_TARGET_FLDS
DROP VIEW REP_ALL_MAPPINGS
DROP VIEW REP_ALL_MAPPLETS
DROP VIEW REP_ALL_TRANSFORMS
DROP VIEW REP_WIDGET_INST
DROP VIEW REP_WIDGET_DEP
DROP VIEW REP_WIDGET_ATTR
DROP VIEW REP_WIDGET_FIELD
DROP VIEW REP_MAPPING_UNCONN_PORTS
DROP VIEW REP_MAPPING_CONN_PORTS
DROP VIEW REP_METADATA_EXTNS
DROP VIEW REP_METADATA_EXTN_DEFINES
DROP VIEW REP_ALL_TASKS
DROP VIEW REP_ALL_SCHEDULERS
DROP VIEW REP_WFLOW_VAR
DROP VIEW REP_EVENT
DROP VIEW REP_TASK_INST
DROP VIEW REP_WORKFLOW_DEP
DROP VIEW REP_TASK_ATTR
DROP VIEW REP_SESS_WIDGET_CNXS
DROP VIEW REP_COMPONENT
DROP VIEW REP_SESS_PARTITION_DEF
DROP VIEW REP_SESS_CONFIG_PARM
DROP VIEW REP_WFLOW_RUN
DROP VIEW REP_TASK_INST_RUN
DROP VIEW REP_DEPLOY_GROUP
DROP VIEW REP_DEPLOY_GROUP_DETAIL
DROP VIEW REP_LABEL
DROP VIEW REP_LABEL_REF
DROP VIEW REP_USERS
DROP VIEW REP_USER_GROUPS
DROP VIEW REP_GROUPS
DROP VIEW REP_REPOSIT_INFO
DROP VIEW REP_SERVER_INFO
DROP VIEW REP_SUBJECT
DROP VIEW REP_SERVER_NET
DROP VIEW REP_SERVER_NET_REF
DROP VIEW REP_VERSION_PROPS
--------------------------------------------------------------------------------
-- Conversion Views Drop
--------------------------------------------------------------------------------
DROP VIEW V_PC8x_MASTER_ELEMENT
DROP VIEW V_PC8x_MASTER_ELMNT_ATTR
DROP VIEW V_PC8x_MASTER_ELMNT_ATTR_1
DROP VIEW V_PC8x_MASTER_ELMNT_ATTR_2
DROP VIEW V_PC8x_MASTER_ELMNT_ASOC
DROP VIEW V_PC8x_MASTER_EXPRESSION
DROP VIEW V_PC8x_MASTER_CONNECTION
DROP VIEW V_PC8x_MASTER_DEFILE_CNX
DROP VIEW V_PC8x_MASTER_RUN
DROP VIEW V_PC8x_MASTER_TSK_LOG
DROP VIEW V_PC8x_MASTER_EVENT
DROP VIEW V_PC8x_MASTER_PARTITION
--------------------------------------------------------------------------------
-- Master Views Drop
--------------------------------------------------------------------------------
DROP VIEW V_PC8x_ELEMENT
DROP VIEW V_PC8x_ELMNT_ATTR_1
DROP VIEW V_PC8x_ELMNT_ATTR_2
DROP VIEW V_PC8x_ELMNT_ASOC
DROP VIEW V_PC8x_CONNECTION
DROP VIEW V_PC8x_DEFILE_CNX
--------------------------------------------------------------------------------