Remote DB2 Configuration Server & Parallel
Posted: Tue Jan 13, 2009 8:12 am
ETL Server: Running DataStage 8.0.1 on AIX 4.3 with DB2 Connect Client
Database Server: Running DB2 9.1 on AIX 4.3
I have exising DataStage server jobs that utilize DB2/UDB API stage and DB2 Bulk Load Stage.
Our DBA team has recently migrated to a DPF configuration on the Database server. I've heard rumblings about existing server jobs running slower with the DPF change. Are there any DB2 client or server settings that should be adjusted in light of the DPF change?
We will be starting some new application development using parallel jobs. We'd like to use the DB2 Enterprise stage. Can the DB2 connect client be configured to support the DB2 API stage and DB2 enterprise stage simultaneously (same DB2 instance)? The IBM consultant that did our installation implied that it wasn't possible.
I'm just starting a detailed review of the DB2 Connectivity PDF before launching into some testing.
Any insight is appreciated.
Thanks,
Mike
Database Server: Running DB2 9.1 on AIX 4.3
I have exising DataStage server jobs that utilize DB2/UDB API stage and DB2 Bulk Load Stage.
Our DBA team has recently migrated to a DPF configuration on the Database server. I've heard rumblings about existing server jobs running slower with the DPF change. Are there any DB2 client or server settings that should be adjusted in light of the DPF change?
We will be starting some new application development using parallel jobs. We'd like to use the DB2 Enterprise stage. Can the DB2 connect client be configured to support the DB2 API stage and DB2 enterprise stage simultaneously (same DB2 instance)? The IBM consultant that did our installation implied that it wasn't possible.
I'm just starting a detailed review of the DB2 Connectivity PDF before launching into some testing.
Any insight is appreciated.
Thanks,
Mike