DSXchange

basically, statistics are used for database optimizer to build most proper access plan to achieve best performance

it seems you have the same problem as below APAR.

http://www-01.ibm.com/support/docview.w ... wg1JR31652

if so, you need to install either 8.0.1 fixpack 3 or 8.1 fixpack 1

Only job design could be imported from DS 7.5 to DS 8.x. Hopefully you have a copy of production designs in your CVS, otherwise you have to import them from Dev environments that is risky.

yes, you need recompile all of them. you can do a batch compile, it takes some time if you have many jobs.

The DataDirect ODBC drivers support 5.0 and later versions of *MySQL* Commercial or *MySQL* Enterprise servers. They do not support any of the *MySQL* Community servers. You must use either the Commercial or Enterprise edition with the ODBC drivers.

Be careful when you choose to disable the index before load and then enable it after load, particularly you have unique index on target table.
you should ensure that there is no violation of the unique constrain, or your table will be read only and the DBMS will not let you enable the unique index.

suresh,

there are two points you could have a check.

1. the load of target database or ETL server during your runs might be different.
2. if you have indexes on target table, the performance may be different when the data volume of target tables are different.

source dsenv before your try the command

There is a file named "DSParam" that includes parameters information.

I don't see anywhere to set NLS in Connector Stage. There is no NLS tab in DB2 Connector, Oracle Connector, ODBC Connector and Teradata Connector. How can I handle character set conversion from source connector stage to target connector? It seems I need to add a transformer to do it now. Hope there ...

If you installed your 8.5 Server at the default location, you can find it in /opt/IBM/InformationServer/Server/branded_odbc/bin

Christian, When we are talking about ODBC, there are two concepts, ODBC drivers and ODBC manager. In the unix environment, DataDirect is the default ODBC manager shipped and worked with Datastage. And the ODBC drivers that provided by DataDirect could work fine with it's ODBC manager, however, ODBC ...

check if you have reference integrity on that table. if so, your table might be in the Set Integrity Pending No Access state. Ask your DBA to Execute the SET INTEGRITY statement to put the table active.

there is a IBM WebSphere Information Services Director User Guide in 8.1 documentation

I tried this using an ODBC connector while I extracted data from as400 multi-member tables. it works file to me.

I suggest you bind ddcs400.lst on your db2 if you have not done it.