Search found 53125 matches

by ray.wurlod
Tue Nov 08, 2011 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Parallel Job Hang
Replies: 9
Views: 12361

Welcome aboard.

Usually the first thing I look for in a "hang" situation is database locks or deadlocks. Work with your DBA on this. Don't forget the XMETA database.
by ray.wurlod
Tue Nov 08, 2011 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help in Job design
Replies: 13
Views: 3747

Hi pandeesh, U said in previous job u used hash partition..after that for target dataset u use same partion it wil give best performance then auto ..and continue that dataset as a source dataset in current job u said .. i think it will work.. U is one of our posters. U has had no involvement in thi...
by ray.wurlod
Tue Nov 08, 2011 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help in Job design
Replies: 13
Views: 3747

If repartitioning is occurring then the job design will have a "bow tie" link marker icon on the link.
by ray.wurlod
Tue Nov 08, 2011 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Source record counts
Replies: 2
Views: 868

There's no issue. @INROWNUM is performing as documented. If you need this across all nodes, you need recourse to the DataStage API.
by ray.wurlod
Tue Nov 08, 2011 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata load takes longer time
Replies: 4
Views: 1414

Why aren't you using bulk mode? That would almost certainly boost performance.
by ray.wurlod
Tue Nov 08, 2011 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query Reg. Join Stage
Replies: 5
Views: 1316

The same join type is used pairwise on all input links to the Join stage. (Join type can only be set once in the stage.) Specify the join type that you actually require.
by ray.wurlod
Tue Nov 08, 2011 3:11 pm
Forum: General
Topic: Background information about a job
Replies: 12
Views: 3027

DSDetachJob() takes a single argument (not two) and that needs to be a job handle, not a job name. If you must use kill, make it more gentle, maybe -15 so that the job gets some grace time to close files, release locks, etc. SIGKILL (-9) can leave locks. Your other problem, for parallel jobs, is tha...
by ray.wurlod
Tue Nov 08, 2011 2:58 pm
Forum: General
Topic: Xmeta vs Hashed files
Replies: 6
Views: 2865

The local repository (which you have called "hashed files" and which was originally built on the UniVerse RDBMS) is the original, and continues to be used primarily for design-time operations so that you don't commit anything to XMETA until you are ready to. For performance reasons you can...
by ray.wurlod
Tue Nov 08, 2011 2:56 pm
Forum: General
Topic: Batch job calling the sequences mentioned in a file.
Replies: 5
Views: 1562

You can create batch jobs in the Director client. This batch executes one job after another.

Anything more complex than that you would need to create a sequence job.
by ray.wurlod
Tue Nov 08, 2011 2:54 pm
Forum: General
Topic: It's possible to import jobs from 8.5 to 8.1
Replies: 2
Views: 974

Officially the answer is "no".
by ray.wurlod
Tue Nov 08, 2011 2:53 pm
Forum: General
Topic: DataStage Architecture
Replies: 1
Views: 805

It's fairly well described in the Planning, Installation and Configuration Guide. Is there any specific question that you have?
by ray.wurlod
Tue Nov 08, 2011 2:52 pm
Forum: General
Topic: Getting the stage type in DSX
Replies: 4
Views: 1276

Look for the class of object, for example CSequentialFileStage.
by ray.wurlod
Tue Nov 08, 2011 2:51 pm
Forum: General
Topic: Datastage8.5 compatability
Replies: 1
Views: 716

You could find this out for yourself from the IBM Information Center - follow the "System Requirements" link. Windows 7 is certainly NOT supported for anything but the client tier. From the website indicated you can determine whether, and which variants of, Windows 7 might be supported for...
by ray.wurlod
Mon Nov 07, 2011 11:52 pm
Forum: Data Integration
Topic: Limiting Business Glossary Author Role
Replies: 4
Views: 10121

Limiting Business Glossary Author Role

Is it possible to change the Business Glossary Author role to prevent them from creating Categories?
by ray.wurlod
Mon Nov 07, 2011 11:51 pm
Forum: Data Integration
Topic: Business Glossary Notification
Replies: 6
Views: 14838

Business Glossary Notification

Is there a notification mechanism when a Term is created in Business Glossary?

If not, is there any Report that could be scheduled to run periodically? It seems to me that there's a paucity of reporting available out of Business Glossary, even in version 8.7.