Search found 53125 matches

by ray.wurlod
Thu Jun 12, 2008 5:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom error - DSP.Close
Replies: 5
Views: 3984

DSP.Close can raise an alert if SAP does not respond in a timely fashion.
by ray.wurlod
Thu Jun 12, 2008 5:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: data extract and load SAP CRM
Replies: 5
Views: 2327

There are extract and load PACKs for SAP, which you need to purchase from the vendor (IBM or a reseller).

These are certified by SAP AG as generating legal ABAP code.
by ray.wurlod
Thu Jun 12, 2008 4:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash tuning on old, old version
Replies: 1
Views: 849

Provided there is a VOC pointer to the hashed file (not, it's not "hash" file), the command is ANALYZE.FILE hashedfilename STATS
by ray.wurlod
Thu Jun 12, 2008 4:52 pm
Forum: General
Topic: job locks release
Replies: 3
Views: 1748

The first question should have been WHEN to release locks? There are times when you should not, because it is not safe to do so.
by ray.wurlod
Thu Jun 12, 2008 4:49 pm
Forum: General
Topic: DataStage Client Installation
Replies: 3
Views: 1264

What operating system do you have? IBM recommend 2GB minimum for the client, so your machine may be running out of memory.
by ray.wurlod
Thu Jun 12, 2008 1:07 am
Forum: General
Topic: DataStage Backup and Recovery from Server
Replies: 21
Views: 18305

... and Routines upon which the job depends. Oh, yes, I'm a great believer in using Data Elements to map my business metadata into DataStage. And I'd like to have each table definition that refers to the job restored as well. ag_ram, can you please advise how to do all those things in uvrestore, wit...
by ray.wurlod
Thu Jun 12, 2008 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Information Server Console logon error
Replies: 3
Views: 2311

Installation on Windows XP (while not supported) must be performed by the Administrator user - not any other member of the Administrators group. It is wise to have set up an IIS administrator user ID (such as isadmin), a DataStage administrator user ID (such as dsadm), and a DB2 administrator user I...
by ray.wurlod
Thu Jun 12, 2008 1:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Report
Replies: 4
Views: 1477

Yes. The dsjob command has a -report option.
by ray.wurlod
Thu Jun 12, 2008 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Enterprise Stage with Transformer Stage
Replies: 14
Views: 2623

You possibly have a duplicate node name in your configuration file.
by ray.wurlod
Thu Jun 12, 2008 12:57 am
Forum: General
Topic: DataStage Backup and Recovery from Server
Replies: 21
Views: 18305

I have deleted the job. I have no idea what the job number is, much less the key values for DS_JOBOBJECTS to specify to uvrestore. How, indeed, can you be certain that you have identified ALL the DS_JOBOBJECTS records for this job? Further questions. What if I want to restore the job executable (eit...
by ray.wurlod
Wed Jun 11, 2008 9:15 pm
Forum: General
Topic: Importing COBOL Copybook Into The CFF Stage
Replies: 1
Views: 1167

You import the COBOL FD into the Repository, not into the stage.

Within the CFF stage, you use the Load button on the Columns tab to load the table definition from the repository into the stage.
by ray.wurlod
Wed Jun 11, 2008 9:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Fixed length record file
Replies: 9
Views: 4836

As you import the table definition check the "Fixed width" check box on the Format tab, then enter 18,15,7 in the column widths field. Select the Define tab and note that the widths are recorded as "Display width". Make any other required changes, such as addition of data elements and descriptions, ...
by ray.wurlod
Wed Jun 11, 2008 9:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Post-installation problems with IBM info server
Replies: 17
Views: 8625

Open a Command window in the project and execute the LIST.READU command. Let us know what you see. Unfortunately there is no copy/paste from the Command window. Other commands that might prove useful are:
SELECT * FROM UV_SCHEMA;
SELECT * FROM UV.ACCOUNT;
by ray.wurlod
Wed Jun 11, 2008 8:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Administrator
Replies: 14
Views: 3986

Try using a machine name rather than IP address.
by ray.wurlod
Wed Jun 11, 2008 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Post-installation problems with IBM info server
Replies: 17
Views: 8625

Can you connect to the server using the DataStage Administrator client?

If so, can you get to this project's properties?