DSXchange

Hi! When I try to execute a job with an xml input stage, I get the following error message: main_program: Fatal Error: Fatal: Shared library (xmli.so) failed to load: errno = (8), system message = (rtld: 0712-001 Symbol execute__Q2_10xslt4c_1_98FunctionCFRQ2_10xslt4c_1_921XPathExecutionContextPQ2_1...

It might also be that the inode table for that particular file system is full. Can u please tell if there is a command that we can execute from the administrator command line prompt to know whether the Inode table for a file system is full ? The issue i am facing is a Job runs fine sometimes but th...

Hi .. i was searching thru this error and got across this post. Can u please tell me where to set this MAXUPROC variable.

thanks in advance.

Hi .. We recently upgraded the Datastage from 7.1 to 7.5.2 We r working on verifying whether the DB2 EE stage functioning properly or not.. When i run a Job to Either read from a Table or Update a Table i get the following errors: ##W TFPA 000015 16:21:41(000) <node_ccsidbu1> Warning: unable to chdi...

Hi Recently in Development environment we Upgraded the DB2 version from 8.1 to DB2 UDB v8.2.6 (Fixpak 13). The Datastage is on 7.1r2 . The ETL jobs which use the API stage are functioning properly but the Jobs which use the DB2 EE stage are failing with fatal errors such as: Error Idx = 1; DB2 Drive...

code1 val1 group1 ____________________________________ 1 p abc 0 p abc 1 a fpg 0 a fpg ------------------------------------------------ Before getting to design.. i wanted to know .. How many times can a Group appear in a file. i.e., say do u have any requirement that "abc" appears only tw...

Hi Sam.. There is one possible reason for the Low values. When u put a varchar field into a Char(N) Field, then EE Stage by default appends the remaning length with Lower values. The solution for this is U trim the Source Field and explicitly append the rest of the Field Lenght with Spaces. ex: Trim...

thanks for the reply Mr.Vmcburney. But its my fault that i did not provide all the info thats required. I am running the QS Jobs using from the Unix command prompt from the DS Batch job. I am using theJobname.par file for running. so in that case, where i am not using the QS for DS plug-in and so i ...

Hi all--

Can we Run the Quality Stage job which uses the Match stage to be run in Parallel mode. Would there be any abnormality in the operation and in Match results as i am afraid the partitioning obstructs data from getting matched.

Thanks.

If have a Requirement where i need to find the Nearest Branch to a Customers Address. For this we intend to use Geolocator. what we plan to do is 1) Find the Latitiude and Longitude of the Customer Address by using the QS Match Stage and by matching the Customer Address file with the XXX Geolocator ...

Hi,

i am trying to use a the XML Input stage. I used a Folder--> XML Input stage --> Sequential file. The error i get is "Unable to resolve prefix 'ns1'.
pattern = '/ns1:batch'(Unknown URI, 15, 66)
Remaining tokens: ('/')"
Can anyone suggest?
Thanks.

Hi- So basically what u want is u need to eliminate the special characters from ur Data file. I am sure this can be achieved by using a Parse Stage in Quality Stage where u can specify which character should be replaced by what. But this is slightly Cumbersome because u need to specify all the speci...

Hi All!!!

Can i know where could i get the information regarding the Various files which get created when a job is deployed. I need the information of what the ARDS file, .MAT, etc files are meant for.

Thanks!!!

Hey!! This can be done easily in a Parse stage. But this is possible if, all the changes that u require to perform are in a singe column. I.e If u require to do these manipulations on a single field then, u have an option in parse stage to specify the input value and the value u need to replace it w...

Hi All,

i need to run datastage jobs from unix.
if i scheduled a job from datastage and i use a command crontab -e then i should see that job scheduled right!
if it is wrong correct me.
but i am not able to find my scheduled jobs when i do a crontab -e.
Any suggestions?

Thanks!