Search found 4992 matches

by kcbland
Mon Jun 05, 2006 11:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command Line Export
Replies: 3
Views: 695

The whole project only, but not specific categories.
by kcbland
Mon Jun 05, 2006 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Limit for development projects on Unix server
Replies: 6
Views: 2137

On HP/UX you might have glance installed. Try using it to monitor server load.
by kcbland
Fri Jun 02, 2006 3:54 pm
Forum: Site/Forum
Topic: Video Tech Tip Series - FEEDBACK
Replies: 49
Views: 73519

Speeeaak mmooorrree slooowwwlyyy. Bigger screen, your Hollywood looks can't be appreciated on that scale.
by kcbland
Thu Jun 01, 2006 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: remove character symbols
Replies: 9
Views: 1912

OCONV(link.column, "MD22") will shift 2 decimal places and round to 2 decimal places. Read your DS BASIC manual for information about OCONV. While you have the manual open, learn all of these functions: INDEX, COUNT, FIELD, FMT, OCONV, ICONV, TRIM, CONVERT, CHANGE, EREPLACE, LEFT, RIGHT, SUBSTRING. ...
by kcbland
Thu Jun 01, 2006 9:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can someone explain me the datastage architecture clearly?
Replies: 9
Views: 5446

We build "jobs" which are nothing more than graphical designs of programs. It's important, just like with any language or tool, to develop standards and practices that are repeatable, scalable, meaningful, and add value to the design in a descriptive way. Using judgment and experience for developing...
by kcbland
Thu Jun 01, 2006 6:40 pm
Forum: Infosphere Master Data Management
Topic: what is the basic difference between kimball and billinmon
Replies: 10
Views: 16573

Take a peek here: m This is my favorite diagram, because it shows the elements in a fully matured environment. I really like showing folks this diagram, because it settles all disputes over where the ODS is positioned. Each element in the diagram serves a purpose. Staging is about keeping original d...
by kcbland
Thu Jun 01, 2006 6:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs suddenly become un-runable
Replies: 9
Views: 2391

Intermittent "run-ability" can also occur when the T30FILES value is exceeded. Too many jobs running can overflow the default setting. I know you're using PX, but Sequencers are Server jobs, as well as all of the log, config, and status files are dynamic hashed files. Check your uvconfig file and if...
by kcbland
Thu Jun 01, 2006 5:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File Write Failure
Replies: 4
Views: 1183

Wow, I'm more off today than my usual. :oops:
by kcbland
Thu Jun 01, 2006 1:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequencer fatal timeout error (-14)
Replies: 3
Views: 1040

It depends on your hardware configuration, memory, etc. That's why I recommended talking to tech support, they can get you setup better. However, ultimately, the problem is an overloaded server that can't task switch between processes fast enough and thus DS has troubles. Tech support is bound to te...
by kcbland
Thu Jun 01, 2006 12:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequencer fatal timeout error (-14)
Replies: 3
Views: 1040

Look at the cpu utilization using prstat on Solaris or top or glance. This is a common issue, discussed at length. There are some adjustments to GLTABSZ and RLTABSZ, MAXRLOCK and UVSYNC that might help, but isn't guaranteed. You'll need to experiment and see what helps, but ultimately, Ascential nee...
by kcbland
Thu Jun 01, 2006 12:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with RT_CONFIG file
Replies: 6
Views: 2911

Arnd was talking about releasing locks, kicking out users, etc. The last resort for releasing locks and killing runaway job zombie threads is a recycle.
by kcbland
Thu Jun 01, 2006 12:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with RT_CONFIG file
Replies: 6
Views: 2911

If all fails, just stop and restart your DS server. This has no effect. The pieces and parts to this file are missing. Either the VOC entry points to missing constituent parts, or there's a permissions issue on the parts. The easiest thing to do is just copy another RT_CONFIGxxx directory contents ...
by kcbland
Thu Jun 01, 2006 12:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routines Getting Locked
Replies: 4
Views: 1051

There's no way the lock table is empty. A Designer, Director, or Manager client session has active locks. Make sure you're telnet'd to the right server. Locks are project (account) independent, so when you connect make sure you specify the UV project (the administration project). UNLOCK is catalogue...