DSXchange

If your referring to the bulk load stage then both would be the same I suspect. I dont have any test results to back it up. But technically both use DB2's bulk utility. Hence it should be the same. If your talking about the DB2 API stage and DB2 enterprise stage then the latter is way way faster as...

What's have a better performance to do a DB2 Load by ServerJob or ParallelJob?

Regards,

Fernando

Check to see if your database is partitioned - your DBA should be able to determine that. Brad The manual says: The database must be DB2 Enterprise Server Edition with the Data Partitioning Facility (DPF) option installed. That was the problem, it is not enough only the DPF feature installed. To wo...

Thanks a lot friends! :D

Best Regards,

Fernando

Especially on AIX it takes it significant amount of time to realize that the connection for the port is broken and it need clan the port. And You can set tcp_finwait2 to a lower value to take care of that. I set it to 60 which is 30 seconds. The default I believe is 1200, which would be 600 seconds...

To complete. The correct steps to start the datastage service are: start 1 -> Connect with user dsadm 2 -> set DSHOME enviroment variable (DSHOME=/datastage/Ascential/DataStage/DSEngine;export DSHOME) 3 -> go to DSHOME/bin 4 -> ./uv -admin -start PS: 1 - dsadm is a administrator user, but he doen'st...

chulett wrote:From $DSHOME, step #6 would actually be:
6 -> ./bin/uv -admin -stop

You are right.

But changing my step 5 to "-> go to $DSHOME/bin " then my step 6 works :D .

My Operating Systems is "Unix AIX 5.3 ".

Fernando

The correct steps to stop the datastage service are: 1 -> Connect to the server with user dsadm 2 -> ps -ef | grep dsapi 3 -> ps -ef | grep dscs 4 -> with any connection or job running kill by unix 5 -> go to DSHOME 6 -> ./uv -admin -stop PS: 1 - dsadm is a administrator user, but he doen'st need to...

Did you do a netstat -a|grep dsrpc to see if the listener is there? yes, and is there. Can anyone else connect to this instance? No If your problem is username/password, did you check to make sure your system booted correctly? Second the Unix guy everything was ok. If you "had" to restart...

Its complaining "User name and/or password incorrect" If its problem with client, check if you can loging into the UV account from your server. cd `cat /.dshome` . ./dsenv /bin/uv This should give you the ">" UV prompt. I think that there is no problem with my client because I'm...

ray.wurlod wrote:Is dsrpcd actually running? Use ps -ef | grep dsrpcd | grep -v grep to find out. Ah, yes, you did; I see it at the end of your post. This daemon should be automatically started, as p ...

Yes, dsrpcd is running.

Fernando

Hi, I had to re-start my server! I think that I used the right way: 1 - Connect with user dsadm 2 - cd /datastage/Ascential/DataStage/DSEngine/bin 3 - ./uv -admin -start 4 - ./dsrpcd But, when I try to connect from client, I'm getting the follwoing problem: Code: Failed to connect to host: dsserver,...

What DB2 version are you using? I checked on the IBM website, and it looks like the variable DB2_PARTITIONEDLOAD_DEFAULT may not be necessary for v8.1 or later. We are using 8.2 and it is not set. You can determine its value with the db2set command: Brad, second my DBA we are using v8.2 and the var...

Try disabling automatic load ... Sorry Ray, but how can I do this? :oops: Other thing: inspecting the control file generated by DataStage The log show me the following: 1 - DB2 Load Binary Error. 2 - SQLCODE = -27959; SQLSTATE= /datastage/scratch/ordb21974350690d9f3f_ 3 - SQL27959N The partitioned ...

DO an exact search on 'SQL27959N'. Brian a complete DB2 search give me the following: -------------------------------------- SQL27959N The partitioned database configuration option "<option-name>" is invalid. Reason code = "<reason-code>". Explanation: The partitioned database c...