DSXchange

What do you mean? Sun Solaris 2.8 is the OS. It is also UNIX. NOFILES is also a UNIX kernel parameter. You need to change MFILES to 200 or more which should be plenty. NOFILES is large enough. Do you have jobs with more than 100 links? There is another parameter for the number of DYNAMIC hash files....

I think you need to add a -wait to your dsjob so they do not run at the same time.

MFILES is the number of files which Universe can have open within one process. This has to live under the limit at the UNIX level. Some UNIX platforms do not have a limit. NOFILES is the UNIX kernel parameter which sets the limit at the UNIX level. If MFILES allows a process to exceed the UNIX level...

NOFILES has a direct relationship to MFILES in uvconfig. I think MFILES can be 2 less than NOFILES. Anyway DataStage performs best when you make MFILES as large as possible otherwise it will close a file before it opens another when it gets close the MFILES limit.

You have to pay extra for every server version you install. Your server should not slow down with a few developers on it. It is probably the jobs running that are slowing you down. You may need to test big slow jobs at night. We do that now. It works well. You want your developers to be productive.

The bitmaps are large files. Never seen one over 5mb before though. Converting them with SnagIt or IrfanView will dramtically reduce their size. You can convert to jpg and then back to bmp and they will be much smaller.

Put it in a hash file. It would run lots faster than looping through a sequential file over and over.

You guys need to download DSaveAsBmp.bat. It can do a whole project in a few minutes and it is free. The bitmaps are nice enough. You have to click a few times because of a bug in Designer but it is still pretty fast.

When bulk loaders were first invented you could only bulk load into tables without constraints and indexes. As they got more complex they could bulk load into almost anything. Now you are trying to parallel bulk into a table with triggers and/or constraints. The database is complaining about the lev...

Vincent Actually it is free. The Designer has a command line option to save as bitmap. I turned this into a batch file which will save all jobs in a project as a bitmap. I also added it to the html documentation generated by an Ascential routine called JobReport. I also was added to my html document...

We wanted more restrictive access so we added the new project. We added a UNIX group named dstage2. cd $DSHOME vi dsenv # add umask 007 vi sample/ds.rc # change umask to 007 chmod -R 777 catdir sql DS_LICENSE cd ../Projects chmod -R 4770 . chmod 4770 . cd NewProject chgrp -R dstage2 . vi .developer....

I think someone spent too much time changing diapers again.

I think if you added one more feature it would explode. It is a very nice shell script. Very well written. This sounds like something quick and dirty. A one time process.

Ken Bland posted a shell script to run jobs. It has examples of how to add parameters to the command line. It is probably way overkill for what you want but should get you pointed in right direction. What you need to add on the above is PARAMNAME='PARAMVALUE' like TargetDSN='Ora3'.

Do a search this has been covered a lot. Ray posted several routines. If you cannot find it then let us know.