Search found 19 matches
- Sun Apr 01, 2012 5:59 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Error during importing metadata in Information Analyzer
- Replies: 0
- Views: 2521
Error during importing metadata in Information Analyzer
Hi, When i am trying to export the metadata from Oracle DB i am facing the below error. An exception was received from the handler: ODBC function "SQLGetInfo(SQL_CATALOG_NAME)" reported: SQLSTATE = HYC00: Native Error Code = 0: Msg = [Microsoft][ODBC driver for Oracle]Driver not capable Th...
- Sat Nov 13, 2010 12:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What are Routines and where are they get created?
- Replies: 1
- Views: 1476
What are Routines and where are they get created?
Can any explin m about routines and it types and alo how they are created in Datastage.
- Thu Dec 31, 2009 1:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Job Long Running on DS 753 and DataBase Oracle 10g
- Replies: 1
- Views: 1927
DataStage Job Long Running on DS 753 and DataBase Oracle 10g
Hi, We are facing perfomrance issue when we are trying to run one of the DS job which contains many oracle stages as lookup's.When contacted DBA he confirmed that there is only one connection from DataStage and it is trying to fetch the data from all the oracle stages. Where as the same job in our o...
- Wed Dec 02, 2009 8:27 am
- Forum: IBM QualityStage
- Topic: DS Jobs Long Running Issue
- Replies: 1
- Views: 1998
DS Jobs Long Running Issue
Hi, We have upgraded our DataStage from 751 to 753 and also upgraded our oracle to 9i to 10g. The issue is few of our jobs are running for long time,fo example job name abc which used to run for 1 min in older version is now currently running for more than 2-3 hours and gets hanged.The job uses simp...
- Thu Nov 19, 2009 12:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Upgradation issue
- Replies: 3
- Views: 1984
- Thu Nov 19, 2009 9:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Upgradation issue
- Replies: 3
- Views: 1984
DataStage Upgradation issue
Hi all, We have upgraded our Datastage(7.5.1 to 7.5.3) and Oracle(9i to 10g) in our current environment. The issue here is few of the DS jobs which used to run just for 1 min in our previous environment are now running for long time and they are not even getting completed. We are killing them manual...
- Wed Nov 11, 2009 1:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Environmental issue
- Replies: 1
- Views: 1571
Datastage Environmental issue
Hi, Can any one please let me know why $APT_NO_JOBMON varaible is used. This has been called in the parameters in one of our DS parallel jobs. As part of our migration we want to delete this variable. Deleting this variable will effect the job logic? Please let me know whether we can delete this fro...
- Wed Oct 28, 2009 10:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS job failed due to SQl Loader issue
- Replies: 5
- Views: 6116
Hi Sanjay, Please find the warning it gives us before it gets failed. Oracle_Enterprise_1,0: ld.so.1: sqlldr: fatal: /opt/oracle/client/10.2.0/lib32/libclntsh.so.10.1: wrong ELF class: ELFCLASS32 And there is no log file created for this and when searched for log file in the below location it just d...
- Wed Oct 28, 2009 7:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS job failed due to SQl Loader issue
- Replies: 3
- Views: 2901
Re: DS job failed due to SQl Loader issue
mgendy wrote:did you try to open the log file /abc/ac/02/scratch/ora.20269.404983.0.log ,,
what did you have there ?
There is no such file created. The source for this job is Oracle Enterprise stage and target is also the same.
- Wed Oct 28, 2009 3:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS job failed due to SQl Loader issue
- Replies: 5
- Views: 6116
DS job failed due to SQl Loader issue
Hi, Please find the error below. Oracle_Enterprise_285,0: The call to sqlldr failed; the return code = 35072; please see the loader logfile: /abc/ac/02/scratch/ora.20269.404983.0.log for details. The job is inserting data to theoracle table using Load option, and is getting failed with the error men...
- Wed Oct 28, 2009 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS job failed due to SQl Loader issue
- Replies: 3
- Views: 2901
DS job failed due to SQl Loader issue
Hi, Please find the error below. Oracle_Enterprise_285,0: The call to sqlldr failed; the return code = 35072; please see the loader logfile: /abc/ac/02/scratch/ora.20269.404983.0.log for details. The job is inserting data to theoracle table using Load option, and is getting failed with the error men...
- Tue Oct 27, 2009 12:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Upgradation issue
- Replies: 4
- Views: 2566
Hi, I have recompiled the job and re ran the job through DataStage it ran successfully. But the same job when ran through unix script is getting failed again with the same issue. Note: Before the upgrade we have taken the export of the jobs to our local(XP) machine and after the upgrade we have impo...
- Sun Oct 25, 2009 10:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Upgradation issue
- Replies: 4
- Views: 2566
DataStage Upgradation issue
Hi, Recently we have upgraded the dataStage from 7.5.1 to 7.5.3. After the upgradaton we are facing the issues with the job run. Once the DS job run all the jobs are failing with the below mentioned error: XFM_data_mapping: Failed to load the library "V0S523_jobname_XFM_data_mapping.so"; e...
- Fri Oct 16, 2009 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation of the jobs in DataStage
- Replies: 2
- Views: 1676
- Fri Oct 16, 2009 4:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation of the jobs in DataStage
- Replies: 2
- Views: 1676
Compilation of the jobs in DataStage
Hi,
Can any one let me know, is there any option to complie all the jobs in an DataStage project
Currently the version is 7.5.3
Can any one let me know, is there any option to complie all the jobs in an DataStage project
Currently the version is 7.5.3