DSXchange

I updated LOG IMG.

Hi guys, when I use odbc connecter extract data from MYSQL database. It is abort. The following is log. when I set array size = 1 is fine. But it is low efficiency. Set to 2000(default value) It is abort.

Anybody can help me.

************ Start Display Current Environment ************ WebSphere Platform 7.0.0.11 [ND 7.0.0.11 cf111021.10] running with process name datastage3Node01Cell\datastage3Node01\server1 and process id 29097 Host Operating System is Linux, version 2.6.18-238.el5 Java version = 1.6.0, Java Compiler = ...

Hi guys: I have a urgency issue. I can not start service. When I input "/etc/init.d/ISFServer restart" the service can not start. I open the log file(/opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/server1/SystemOut.log). There is a message. Caused by: com.ibm.websphere.security.Pass...

ray.wurlod wrote:Does a file called DSParams exist in the project directory? ...

Hi man, thank you for your advise. I have to check this file when I saw the problem at first. It is fine.

Hello guys. Today the server admin install a new datastage server for us. But I found the environment is empty. There is no general and parallel in the left tree. Just user_define is there. http://t3.qpic.cn/mblogpic/0f0daa51e99f4630c47c/460 I check with default project dstage1 are same as the pictu...

Hello everyone:
Anyone knows how many processes in the server when the jobs are not running.

By the way, one time I run the jobs the database crash. So the server admin ask me how many processes and what are they when the jobs are not running. I have no idea.

Thank you.

Thank you very much. I already try it. But it is still not work. warning: DB2_UDB_API_9,0: Warning: test_db2_notin_test.DB2_UDB_API_9: SQLExecDirect: Error executing statement 'IMPORT FROM /dev/null/ OF DEL REPLACE INTO TEST3'. See following DB2 message for details. DB2_UDB_API_9,0: Warning: test_db...

I want to use "Import from /dev/null of del replace into tablename", it is does not work.

Sorry. I forget it. I use two DB2 APT stage. One is source table another is target table. I want to extract data from source table and clear the target table then insert the data. I want to truncate table but the target database version is V9.1. "truncate" does not work on it.

HELLO, everyone. I want to clear the table then insert rows. When I choose the option it will be delete the data then it will fill up transactions logs in the database. So I want to clear the data in the before SQL tab. I try to use "Import from /dev/null of del replace into tablename". It...

both of peddakkagari and jwiles are right. but I have another idea to resolve the problem.

you can user transformer stage and use "null handing" function, you can set any value when is null

hello guys: I have a problem on linux server. DB2 instance path:/home/db2inst1/sqllib/db2nodes.cfg I wanna use db2 enterprise I try to configurate "APT_DB2INSTANCE_HOME" like "/home/db2inst1", there is an error"Error executing View Data command:##E IIS-DSEE-TNDB-00534 20:22:...

I got a big trouble.

We I running parallel job on linux server, extract data from db2 table. This table in the SQL replication, the source table get locked, when the job finished, the table deadlocked.

anybody ever got this trouble?

please give me some advice.

Thank you very much.

chulett wrote:I know it's been worded a little oddly but I've been working on the assumption that they want JOB2 to run if JOB1 runs ok or has warnings.

yes, you are right.