Search found 53125 matches

by ray.wurlod
Thu Oct 30, 2008 9:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Missing Folder
Replies: 3
Views: 1510

PREVDTD is present only for deleted and not re-created objects.

Doubtless there is somewhere in the XMETA repository where this information is also kept, but I have not yet had the opportunity to analyze where this might be.
by ray.wurlod
Thu Oct 30, 2008 9:05 am
Forum: General
Topic: export and import job on UNIX
Replies: 14
Views: 18599

Possibly not, however, since it's notoriously difficult to run a BAT file on a UNIX system. The logic could be converted into a UNIX shell script however, and one would need dsexport to be available on the server machine.
by ray.wurlod
Wed Oct 29, 2008 6:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Missing Folder
Replies: 3
Views: 1510

I don't know for sure whether this will work in version 8, but it's worth trying.

Code: Select all

SELECT INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD LIKE '2...' AND CLASS = '2';
by ray.wurlod
Wed Oct 29, 2008 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log Corrupted
Replies: 15
Views: 5197

CLEAR.FILE is probably safer than either of the repair utilities (uvfixfile or fixtool), for various reasons. Reinstate your log purge settings after clearing the log using the Director client.
by ray.wurlod
Wed Oct 29, 2008 1:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log Corrupted
Replies: 15
Views: 5197

Clear or repair the log hashed file. Search here for clues.
by ray.wurlod
Wed Oct 29, 2008 1:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS Language Error 139
Replies: 2
Views: 1162

Search for the exact error message, which I would guess is about the NLS_LANG environment variable, but I'm not going to waste my time speculating. Post the exact error message and we'll be able to be more help, assuming that you don't find what you need when you search.
by ray.wurlod
Wed Oct 29, 2008 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Error connection
Replies: 8
Views: 4065

DS_CONNECT (which may be DS.CONNECT) can be executed through Administrator client Command window. It's an interactive environment so you will need to use the Response window there.

Does it really say "<unix error>" (sic) when failing to import metadata?
by ray.wurlod
Wed Oct 29, 2008 9:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to search a Sequential file for example x.csv in jobs
Replies: 10
Views: 2371

Code: Select all

SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%x.csv%');
by ray.wurlod
Wed Oct 29, 2008 9:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Connector Read/Write issue
Replies: 7
Views: 7220

Insert then select is not permitted in the one stage or the one job (or, therefore, the one shared container) anywhere in a parallel job, because it is a "blocking operation" that thwarts pipeline parallelism.
by ray.wurlod
Wed Oct 29, 2008 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Userid using which the Datastage job is triggered
Replies: 5
Views: 1467

Select Detail view in the Status screen in Director; the user will be displayed there. I believe (without checking) that dsjob -jobinfo command also gives the user ID.
by ray.wurlod
Wed Oct 29, 2008 9:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job reports failure (code 141)
Replies: 2
Views: 936

Please post the exact and complete error message.
by ray.wurlod
Wed Oct 29, 2008 9:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS Problem?
Replies: 10
Views: 9503

You can execute this command from the Administrator client's Command window. Be very sure that you have exclusive access to the project, otherwise your indexes will become invalidated.
by ray.wurlod
Wed Oct 29, 2008 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: universe database
Replies: 5
Views: 1484

There IS a limit with 64-bit hashed files, it's probably more than the operating system file size limit. The theoretical limit is 19 million TB (approximately) but that all has to be on the one file system. Please note also that UniVerse is a separate database product. The DataStage Engine has not b...
by ray.wurlod
Wed Oct 29, 2008 8:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC access to Progress - transaction handling
Replies: 3
Views: 1210

Rows per transaction is available when writing to the database, rather than when reading from it.
by ray.wurlod
Wed Oct 29, 2008 8:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Error connection
Replies: 8
Views: 4065

It's an informational message (connection open), not an error.