Two things to be checked:
1. Permission for 'WORK' database
-Check whether you have appropriate permissions for the 'WORK' database.
2. Space allocated to 'WORK' database
-Check whether sufficient space has been allocated to 'WORK' db.
Search found 74 matches
- Sun Nov 11, 2007 7:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem with the teradata
- Replies: 9
- Views: 7832
- Sun Nov 11, 2007 6:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem with the teradata
- Replies: 9
- Views: 7832
- Tue Aug 28, 2007 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job is being access from another user
- Replies: 9
- Views: 5936
I am using to unlock my jobs.
The message says:
Cant we unlock our own jobs? Otherwise everytime a job hangs, we need to trouble the DS Admin.
Code: Select all
"UNLOCK INODE 182641 ALL"
The message says:
Code: Select all
Insufficient privileges to perform lock maintenance.
- Tue Jul 10, 2007 2:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error: APT_TeraSync: could not create operator sync table
- Replies: 5
- Views: 3800
- Thu Jun 21, 2007 11:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate row error in <DB_NM>.<TBL_NM>. Teradat
- Replies: 1
- Views: 1569
Duplicate row error in <DB_NM>.<TBL_NM>. Teradat
Duplicate row error in <DB_NM>.<TBL_NM>. Teradata DB. ------------------------------------------------------ RowGen -----> TeradataPX Stage There is an INSERT sql in the Teradata PX stage. There are a series of insertions happening on the target tbl in this job. Insert into #TBL_NM_2# ( Select * fro...
- Tue Mar 20, 2007 12:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Segmentation fault (core dumped)
- Replies: 4
- Views: 4479
- Mon Mar 19, 2007 11:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Segmentation fault (core dumped)
- Replies: 4
- Views: 4479
Segmentation fault (core dumped)
Job Design: ODBC ^ | | SEQ_FILE ===> TRANS ===>LOOKUP ===> TRANS ===> SEQ_FILE This job was running fine a couple of days back and now it is aborting every 3rd or 4th run with the following error messages: CLI : [TID: B75F42A0]:[Tue Mar 20 15:14:32 2007] rdacutl.c:496: *** RDA_cliPrepareSQL: can't e...
- Mon Mar 12, 2007 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-12154 Error and Possible Job Corruption
- Replies: 17
- Views: 7924
- Wed Mar 07, 2007 10:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-12154 Error and Possible Job Corruption
- Replies: 17
- Views: 7924
- Wed Mar 07, 2007 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-12154 Error and Possible Job Corruption
- Replies: 17
- Views: 7924
- Wed Mar 07, 2007 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-12154 Error and Possible Job Corruption
- Replies: 17
- Views: 7924
- Tue Mar 06, 2007 11:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-12154 Error and Possible Job Corruption
- Replies: 17
- Views: 7924
ORA-12154 Error and Possible Job Corruption
Job Design 1: Seq_File1 ==> TRANSFORMER1 ===> STP(Stored Proc) ===> TRANSFORMER2 ==> Seq_File2 I was getting the following error. Error: ORA-12154: TNS:could not resolve service name Checked all the ODBC entries in the respective locations. They look ok as there are other jobs using the same connect...
- Tue Mar 06, 2007 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the version number of an executable job?
- Replies: 2
- Views: 1435
How to find the version number of an executable job?
Hi,
I have a project where only the executables have been imported. How do i get the version number of the jobs present here.
I couldnt get it in the DS Manager/Designer through the properties.
Thanks,
I have a project where only the executables have been imported. How do i get the version number of the jobs present here.
I couldnt get it in the DS Manager/Designer through the properties.
Thanks,
- Mon Feb 19, 2007 12:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CONFIG_FILE - Wrong Server Name
- Replies: 6
- Views: 2669
In fact I am using default.apt which has a symbolic link to mellaswds01_11.apt. BTW, the issue is solved. The configuration file was using MELLARWDS01 as the head node before it was changed by the admin to use MELLASWDS01. The DataStage engine had to be restarted(uv -admin -stop/-start) to make the ...
- Sun Feb 18, 2007 7:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CONFIG_FILE - Wrong Server Name
- Replies: 6
- Views: 2669
APT_CONFIG_FILE - Wrong Server Name
I get the following error when I run a job. My project details are: Project Name: METL_SIT_R1 Server Name: mellaswds01 main_program: Fatal Error: An ORCHESTRATE program must be started on a node in the configuration file. This program is running on MELLARWDS01 which is not in the configuration file:...