Search found 25 matches
- Wed Jun 29, 2005 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Px DataSet information
- Replies: 6
- Views: 3205
We had a similar situation a few weeks ago. We almost ran out of disk-space so i wrote some code to search for 'orphaned' data files, and found that we had 142,000 data files with no descriptor... removing them released 60Gb! Anyway, the method i used was to use 'orchadmin -f' rather than '-l' and t...
- Fri Sep 24, 2004 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Doubt in Join Stage
- Replies: 6
- Views: 3925
Hi Yes it is possible to get more rows out than went in... It is the same as SQL if you dont make the full join between tables. I think its called a cartesian product. For example you could have 2 records in one table and 2 records in the join table and get 4 rows out (for each row in the first tabl...
- Thu Sep 16, 2004 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Format for Opening file with Decimal in PX
- Replies: 5
- Views: 3329
I am trying to copy your set-up so that i can see the error - i have created a sequential using your data, but then i need to enter the column definitions as you have. For example; col_1 char 16 dat_1 date 10 col_2 char 18 dat_2 date 10 col_3 char 7 dec_1 decimal 12 2 This seems to work for me, so i...
- Thu Sep 16, 2004 9:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Format for Opening file with Decimal in PX
- Replies: 5
- Views: 3329
- Thu Sep 16, 2004 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warning in the sequential file
- Replies: 2
- Views: 2546
Hi It sounds like there is more data on the row in the source file than has been declared in the schema. If the column is defined as CHAR(10) and the sequential file has a row with 20 characters in it, you will get a message similar to the one you got. The warning says that the column was defined as...
- Tue Sep 14, 2004 1:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Resolving of error in Join Stage
- Replies: 2
- Views: 2694
Hi It might be a problem if the two columns with name had different values in them for the same key values :) When you make a join, PX will propogate all the columns from the primary input link to the output link, plus any 'extra' columns that it finds from the join stage. If you have two non-key co...
- Tue Aug 31, 2004 10:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Environment Variables
- Replies: 2
- Views: 2553
Hi I have a document of unknown origin, and i am not sure if there are any non-disclosure agreements around it, but i can give you these snippets. I hope they mean something to you... APT_BUFFER_MAXIMUM_TIMEOUT is the largest value that the 'bufferop' write timeout will reach (default 600 seconds) A...
- Tue Aug 31, 2004 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join stage warning
- Replies: 4
- Views: 3606
Hi You will get this warning message when you have columns in the join tables which have the same name but which are NOT key columns. The values from only one of these columns can be carried forward when the column names are the same, and these will be from the first link (as defined in the link-ord...
- Fri Aug 27, 2004 1:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Amount of data a dataset can handle
- Replies: 3
- Views: 5678
Hi I guess the maximum size of the dataset will be 150 million * the row width, plus a small amount for the 'file pointer', but the size of each of the actual files making up the dataset will depend on the number of nodes you are running. We have datasets in excess of 20 Gb, but we run with 8 nodes ...
- Fri Aug 27, 2004 12:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error : unable to map file
- Replies: 6
- Views: 6062
- Wed Aug 25, 2004 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date function
- Replies: 7
- Views: 5599
- Wed Jul 28, 2004 3:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Please, HELP
- Replies: 12
- Views: 8405
- Wed Jul 28, 2004 2:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Timestamp
- Replies: 6
- Views: 3667
Hi If you read the sequential file containing the timestamp value in your post, with the column defined as timestamp (which PX expects to be 19 characters in length) then you will get an error. I can replicate your error message by using the timestamp that you used, which is 26 characters long (it c...
- Tue Jul 27, 2004 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg Iconv and Oconv
- Replies: 4
- Views: 4284
- Wed Jul 21, 2004 12:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing parameters for columns
- Replies: 14
- Views: 8573