DSXchange

Versions 5.2.1 onwards I believe! John Leach Database Products Team Leader Polk Leeds Ltd Direct Dial: +44 (0) 113 386 4005 Fax: +44 (0) 113 386 4100 Email: john.leach@polk.co.uk Polk Leeds Ltd N C R House Ring Road West Park Leeds LS16 6TZ -----Original Message----- From: Ricketts, James [mailto:JA...

So which version has it made it into? -----Original Message----- From: Leach, John [mailto:JOHN.LEACH@POLK.CO.UK] Sent: 22 July 2002 11:35 To: datastage-users@oliver.com Subject: RE: Severe slowdown in DS Director screen refresh Thanks Gavin. Unfortunately Ascential have said that Once an unsupporte...

Thanks Gavin. Unfortunately Ascential have said that Once an unsupported patch has made it to a released product, we do not distribute it to customers. I realise you do not want to become the owner of this code but could you send it for us to use please. Promise not to pester you about though!! Chee...

Note that the ORABULK stage is quite slow at creating the Oracle data file when compared to the Sequential file stage. An alternative to the ORABULK stage is to write the Oracle control file yourself and then have a DS job create the data file using a Sequential file stage. Try writing 2 jobs that d...

Hi all, Anyone out there got any guide lines or paper to size hardware requirements for DataStage? Differences like CPU speed to number of CPU, I/O channels, OS type etc Thanks rgds ____________________________________________________________________ Visit us at www.singaporeair.com ________________...

Sorry, the only way to change the licensing on the CLIENT is to re-install. You dont have to uninstall, just do a re-install. SERVER licensing can be adjusted using either DS Administrator, or go to the control panel and the Ascential icon there will let you change licensing. For example, if you onl...

Hi Everyone, When I am inserting rows in to a Oracle table with " Array Size" = 100, "Transaction Size"=100, " Transaction Handling" = 200. The rows are inserted at the rate of 388 - 400 rows per second max. Are there any tuning tips by which I can increase the speed to 1500-2000 recors per second ?...

Open up DataStage Administrator.... -----Original Message----- From: Pelletier, Christian [mailto:CPELLETIER@probusiness.com] Sent: Friday, July 19, 2002 11:47 AM To: datastage-users@oliver.com Subject: License Number Hi all! An easy question for Friday... Where do you find the license number on a D...

Hi Richard, We experienced the same problem. It seems that there is an inefficient internal routine called by the Director and Designer. I think you will find that if you try the Open Job menu from Designer it will be equally slow. There must be some kind of threshhold when you get over 600-700 jobs...

One place is the registry: HKEY_LOCAL_MACHINESOFTWAREAscential SoftwareDataStage ClientCurrentVersion > Depending on the version of DataStage "Ascential Software" may be "Informix" or "Ardent" ... Hopefully not "VMark" - Rob -----Original Message----- From: Pelletier, Christian [mailto:CPELLETIER@pr...

Hi all!

An easy question for Friday...

Where do you find the license number on a DataStage Client desktop once it is installed...?

Thanks

Christian

Hi folks,

Is there anyone know whether DataStage has a plug-in to process ASN.1
data directly? If DataStage does not have a plug-in to support ASN.1
data, any workaround recommended?

Thank you.

Regards,
Melvin

Hi, I am using IBM DB2 EEE as my Data Warehouse. I tried to execute " RUNSTATS" : runstats on table [SCHEMA].[TABLENAME] with distribution and indexes all; in DSDB2 stage SQL->Before, it failed and returned me the following error message: TESTRUNSTATE.DSDB20: [IBM][CLI Driver][DB2/6000] SQL0104N An ...

Raymond Thanks for your assistance, however it seems neither of these solutions work. I find this most strange, because if I constrain the transform with a IsNull(link.column) the empty string rows do not flow through. However using either the If Then Else or Oconv solutions do not convert the null ...

Hi we want to created a batch, where we use the command dsexport to made same backup, of our project Datastage. The only problem is when we try to export same jobs, and the user have the job opened in the designer, is the any parameters of the command dsexport to ignore this cases ? best regards Rui...