DSXchange

No tools you can just use out-of-the-box. Each DataStage site and implementation is different and the type and extent of testing done is dependant upon many factors - both physical and organizational. What kind of testing do you wish to do? DataStage functional? System integration? Regression? I ne...

Hi

Can any one help us How to automate system testing in data stage and are there any Automation tools for Data stage PX.


Thanx in Advance

I would check with your support provider. I just looked through the list of bugs fixed in DataStage V8 Fix Pack 1 and one of them is "Solaris version of ds.rc uses ulimit setting" which can open up speculation that this might be a similar issue to what you are seeing on AIX. Hi ArndW, Due...

Would you be able to get someone with root login to try logging into DataStage at your workstation and test the runtime limit? Also, could you try the following from UNIX cd $DSHOME . ./dsenv bin/dssh {This will put you into the DS shell} SH -c "ulimit -a" QUIT {This will bring you back o...

Hi,

I do not have the root access, but i confirmed with my admin that he has granted unlimited to all properties of ulimit.

I executed ulimit -a for dsadm at os level before and after executing dsenv. the results are the same. I confirm the known facts which you have mentioned.

thanks!

Hi,

I do not have the root access, but i confirmed with my admin that he has granted unlimited to all properties of ulimit.

I executed ulimit -a for dsadm at os level before and after executing dsenv. the results are the same. I confirm the known facts which you have mentioned.

thanks!

Hi ArndW,

I know its really weird, but i dont know how to resolve this.

I restarted the DS server as dsadm. There are no entries for ulimit in dsenv file though there are entries in uvconfig file which you know will not impact if the root and dsadm has unlimited settings for fileblocks.

Thanks

Hi,

I have changed the fileblocks for root user to unlimited and restarted the DS server. I still find the ulimit for dsadm in DS log shows 2 gb though it is unlimited at OS level.

Please help.

Thanks!

Hi ArndW,

Just to add, even after changing the root setting of fileblocks to unlimited, the problem persists.

Thanks

Hi Arndw,

If the root user ulimit settings are overriding the dsadm user's setting, then how are files > 2gb could be created using dsadm at the back end?

thanks

Hi Arnd,

Since i confirmed that the user dsadm has unlimited privilege for fileblocks at OS level, how does the root's privilege interfere with DS execution for creating large files using the user dsadm? Could you please elaborate.

Thanks

Hi, I went thru couple of posts on the same problem as this http://dsxchange.com/viewtopic.php?t=93900&highlight=ulimit&sid=3636a54c672abe0254c5ffa4bea76809 . Problem: Not able to create a sequential file more than 1.5 gb and aborts with the message "File too large". The "ulim...

Hi, I changed my INSTHOME (which is the home directory of the DB2 client instance) in my dsenv file and restarted the server many times. This new value is reflected at the OS level in the dsenv file but when i run a parallel job only the previous value is shown in the log message. I dont have any En...

Hi, I have a small question on performance enhancement. Currently we are having design where source is text file , has transformer,lookup/joiner and then target as DB2. But when we test our jobs with small amount of data (10000 rows) it works fine, when we do volume test with 10 Million record the j...

Just to add to this, I use only the Server and Data Base parameter in the properties of the EE stage.

thanks!