Search found 2886 matches

by qt_ky
Wed Feb 25, 2015 9:05 pm
Forum: General
Topic: Limitation using cat command in command activity stage?
Replies: 9
Views: 1575

8)
by qt_ky
Wed Feb 25, 2015 3:02 pm
Forum: General
Topic: Write datastage log to physical files in unix
Replies: 6
Views: 1468

Try using the first and last event ID options to limit the detailed entries to only the range of event numbers that you want to capture.

Code: Select all

dsjob -logdetail [-useid] <project> <job|jobid> <first event id> [<last event id>]
by qt_ky
Wed Feb 25, 2015 10:36 am
Forum:
Topic: Business Terms to Assigned Assets via the Business Glosssary
Replies: 3
Views: 3481

Assuming it is a bug of some sort vs. a setting change: Get onto your server(s), or ask your admin, to examine the first page or so of the Version.xml file. The default UNIX path for this file is /opt/IBM/InformationServer, however yours may be in a different path. In there you will find specificall...
by qt_ky
Wed Feb 25, 2015 10:21 am
Forum: General
Topic: dscc does not accept /af parameter ?
Replies: 1
Views: 1250

The option you mentioned is there in version 11.3.1.0 but not in 8.7.0.0; not sure when it was first introduced into the dscc command... There are plenty of other commands in 8.7 that support the authfile option. Here is the 11.3.1 usage. /? Show program usage /af (value) Pathname of file containing...
by qt_ky
Wed Feb 25, 2015 7:05 am
Forum: General
Topic: Protect Unprotect DataStage Projects Thru Coomand Line
Replies: 6
Views: 3904

That is correct! Hence the "update" to provide updated information. :D
by qt_ky
Wed Feb 25, 2015 6:59 am
Forum: General
Topic: Limitation using cat command in command activity stage?
Replies: 9
Views: 1575

Rather than listing and looping, consider using a wildcard in the Sequential file stage to process them all at once, such as *.txt.
by qt_ky
Wed Feb 25, 2015 6:57 am
Forum: General
Topic: Limitation using cat command in command activity stage?
Replies: 9
Views: 1575

A few years ago I tested to verify how many files AIX was able to store in a single directory (I think it was a jfs2 file system) and it was able to store exactly 32K files. No idea is Windows file system has any similar limit... I would assume DataStage can easily store such a file listing in memor...
by qt_ky
Wed Feb 25, 2015 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error when compiling a job
Replies: 2
Views: 3339

The part that jumps out at me as being significant:

Error when checking composite operator: Failure forking subprocess: No such file or directory.
by qt_ky
Tue Feb 24, 2015 9:43 am
Forum: General
Topic: Datastage Project import getting stuck
Replies: 14
Views: 3912

Did you choose to automatically overwrite upon import?

Is there a pop up window behind what you see, or perhaps on a 2nd monitor?
by qt_ky
Mon Feb 23, 2015 10:59 am
Forum: General
Topic: How to display project protection status from command line?
Replies: 7
Views: 4079

How to display project protection status from command line?

The dsadmin -protectproject command can only set a project to being protected or unprotected. How can one simply display the project protection status from the command line, or perhaps grep it from some file, without setting it one way or another? I have tried toggling the setting via DS Administra...
by qt_ky
Mon Feb 23, 2015 10:52 am
Forum: General
Topic: Protect Unprotect DataStage Projects Thru Coomand Line
Replies: 6
Views: 3904

Update:

In newer releases, there is a command line option to toggle the project protection setting.

See this topic:

viewtopic.php?p=461655#461655
by qt_ky
Mon Feb 23, 2015 10:49 am
Forum: General
Topic: Protect or Unprotect a project in DS 8.1
Replies: 4
Views: 2954

4.5 year old post, but was incomplete...

The -protectproject option has a TRUE or FALSE argument required.

Code: Select all

$DSHOME/bin/dsadmin -protectproject

Invalid arguments: dsadmin -protectproject TRUE | FALSE <project name>
by qt_ky
Mon Feb 23, 2015 8:25 am
Forum: General
Topic: Improving Sequence Compilation times
Replies: 18
Views: 4949

Often times when the server is very remote (i.e. high network latency), the best option is to stand up remote Windows desktops for the Client tier, in the same data center / on the same remote network as the server. Remote desktop into those machines to do all your client work.
by qt_ky
Sun Feb 22, 2015 7:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RULES TO RETRIEVE DA FROM MORE TABLES IN ONE JOB
Replies: 5
Views: 1717

Use the same general rule as deciding when to sort using the Sort stage vs. using an ORDER BY clause in your query. It depends mainly on the processing power, the degree of parallelism, and the amount of resource contention at the time the job runs on your DataStage server vs. on the database server...
by qt_ky
Fri Feb 20, 2015 6:15 pm
Forum: General
Topic: Custom Pop Up
Replies: 3
Views: 1388

I doubt that level of customization is achievable within DataStage. I would imagine that you could write your own front end user interface using visual basic, or any language, and behind the scene your program could invoke the dsjob command. It may be more effort than it's worth. Within DataStage, s...