DSXchange

chulett wrote:That would be an "HP thing" not a "DataStage thing".

I think so.

I will test this routine on HP Itanium2 environment to observe the behaviour.

You probably need an extra -l option in APT_LINKER_OPTIONS to refer to your shared object. Tranks for your response Ray. I do an "file" command on the library correponding to a buildop, I see the results: ***/buildop/SRMult.sl: PA-RISC2.0 shared library -not stripped So I've changed the n...

how to read the job log and to capture the statistics like datastage job name,start time,end time ,project, duration,sucess etc You can also use the "dsjob -report" command ( check the Advanced Developer's Guide for a list of all available options ). I do prefer to use the XML option beca...

Hello, fridge is right. If TMPDIR is blank then /tmp is used by default. You need to have a dedicated repertory for the temporary space. If this temporary space is used then your lookup data is way too large. You should try consider using a join stage instead ( less performant but better for handlin...

Hello, Have you tried adjusting the DB Options of the TeraData Enterprise stage? I mean "RequestedSessions" and "SessionsPerPlayer". I never worked with a single AMP Teradata system. Our systems are between 2 to 360. But maybe the DB Options can help you to remove the error. Try ...

Hello,

Be sure you have CREATE TABLE rights on your source database in order to be able to have DataStage create the terasync table.

Hello, Regarding APT_PERFORMANCE_DATA, be sure you set it with a valid path. This is not a variable that is boolean. Then you should get something like this : ...... 20060518 15:37:43,0,0,0,#APT_LicenseOperator#,##,describeOperator,,0,0,0,0,[0][0],Start 20060518 15:37:43,0,0,0,#APT_LicenseOperator#,...

Kris,

Seems your table is either an MQT or part of an MQT, or there are constraints references. So this do not allow you to use WITH EMPTY TABLE clause.

Hello,

You can also use the following SQL in order to do a truncate in DB2 :
ALTER TABLE <tablename> ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

Hope this will help.

Thanks Ray, I will look in that direction. When I will have the solution, I will post it here. You may need to be careful with PATH. ProfileStage uses its own Perl command line interpreter (from memory PerlCRT.dll) but other systems (such as Oracle) use something else (Perl58.dll in the case of Orac...

Hello, I have tested the ODBC connection using "example". So the ODBC DSN to the PSDB is working fine. The SQL request "SELECT PROPERTYNAME FROM SYSTEMCONFIG;" is working good. TestConnection is started on the HP box when you try to test connection from the "Connection Manag...

Hello, I am quite new to ProfileStage installation on a mixed environnement. Installing all ProfileStage components on a single Windows box is ok. But for getting performances we need to get the Unix box ( and DataStage PX ) power. We get some problems trying to get the Analysis Server connected to ...

Hello,

I think that if you have not configured the DB2 Enterprise Options, the stage is using the /tmp directory by default for Local Message files and other DB2 load files. You can add the "Message File" options, available in the stage and use your own directory.

Hello Halit I never got this kind of error. But I can give you some extra infos that might help. The table ERR_60093392_2 is created by the Teradata Enterprise stage and is the error table 2 (where duplicate rows are stored) of the fastload. 60093392 is the cookie number that can be found in the &qu...

Piotrek, Best advice I can give you is to import database metadata from the DataStage metadata. Since you have already imported ( e.g from Oracle ) metadata in DataStage, the DataStage metabroker will import those perfectly. You can also use ODBC metabroker or modeling tools ( e.g. Power Designer ) ...