Where is the TMPDIR pointing to? Is it a NFS file system?.
I believe the sqlldr will try to create pipes in this directory and if it is non-NFS then it would throw an error.
Search found 103 matches
- Fri Sep 11, 2009 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGSEGV error occured during loading the data
- Replies: 26
- Views: 17707
- Tue Sep 08, 2009 11:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to create a Dataset
- Replies: 3
- Views: 2806
Resolved. The dataset was originally created using a different configuration file on different boxes where the scratch was defined. When we moved over to new boxes, the job tried to overwrite the existing dataset, but was unable to because of the mismatch in the config files. I manually went and del...
- Tue Sep 08, 2009 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGBUS
- Replies: 2
- Views: 1126
- Tue Sep 08, 2009 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGBUS
- Replies: 2
- Views: 1126
SIGBUS
Hello, I am getting the SIGBUS error in 7.5.1A. Based on a search from this forum, I tried the different options, but it still fails. -Re-running the job - Toggling the apt_monitor_time variable I have been using df -k in the scratch directories to track memory. How do I monitor all the memory a job...
- Sat Sep 05, 2009 10:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to create a Dataset
- Replies: 3
- Views: 2806
Unable to create a Dataset
Hi We have jobs failing in production because it is unable to create datasets based on the defined configuration file. We have a Datastage box and two DB2 boxes where the scratch space is defined. This is the first time we are running the jobs in this environment. Below is the error. /test/test.ds: ...
- Wed Sep 02, 2009 1:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 - Allow read access
- Replies: 1
- Views: 976
DB2 - Allow read access
Hello, Is there anyway I can specify allow read access while using the load option in a DB2 Enterprise stage? I see it can specified in the DB2 Bulk load stage. If Db2 bulk load stage is the way to go for this option to be set then what would be the difference in using the DB2 bulk load stage vs Db2...
- Wed Aug 19, 2009 11:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing string values into SQL query via parameter
- Replies: 2
- Views: 1139
- Thu Aug 13, 2009 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Day in Date
- Replies: 18
- Views: 4562
- Thu Aug 13, 2009 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Day in Date
- Replies: 18
- Views: 4562
- Thu Aug 13, 2009 9:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Day in Date
- Replies: 18
- Views: 4562
- Thu Aug 13, 2009 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number format
- Replies: 3
- Views: 1210
- Wed Aug 12, 2009 3:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number format
- Replies: 3
- Views: 1210
- Sat Aug 01, 2009 7:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing string values into SQL query via parameter
- Replies: 14
- Views: 14784
- Thu Jul 30, 2009 8:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing string values into SQL query via parameter
- Replies: 14
- Views: 14784
- Wed Jul 29, 2009 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing string values into SQL query via parameter
- Replies: 14
- Views: 14784