Search found 2886 matches

by qt_ky
Fri Jun 20, 2014 5:10 am
Forum: General
Topic: Confirm encrypted password is set to $PROJDEF?
Replies: 16
Views: 6734

The simple way, export & view, has been suggested above. Have you tried it??
by qt_ky
Thu Jun 19, 2014 11:31 am
Forum: General
Topic: Confirm encrypted password is set to $PROJDEF?
Replies: 16
Views: 6734

Export DSX files having the job in question and a job you know contains $PROJDEF. The comparisons suggested above can be done against the encoded text you find within the DSX files when using a text editor.
by qt_ky
Thu Jun 19, 2014 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I read a DBASE DBF file?
Replies: 10
Views: 2688

ODBC stages are the only stages I know of that can read DBF files.
by qt_ky
Wed Jun 18, 2014 8:11 pm
Forum: General
Topic: Space issue for XMETA_DATA tablespace
Replies: 9
Views: 2432

Check the Information Server Web Console for any special or custom detailed logging (tracing). If it is turned on for too long, it can eat up the repository space. I saw this happen on a PMR one time. Detailed logging was enabled while reproducing a problem, and then left on. Within a few days, XMET...
by qt_ky
Mon Jun 16, 2014 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Reading Problem?
Replies: 3
Views: 1494

Is the error coming when you View Data from Designer, in the job log when you run the job, or as a web service response?
by qt_ky
Sun Jun 15, 2014 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file clarification
Replies: 7
Views: 2387

Constraints are very useful. Why would someone suggest not to use constraints?
by qt_ky
Sat Jun 14, 2014 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: New XML Stage Issue
Replies: 11
Views: 6125

Try waiting two business days.
by qt_ky
Thu Jun 12, 2014 8:18 pm
Forum: General
Topic: Environment Variable
Replies: 7
Views: 1343

There is a topic on this very site about decoding the default env var "encryption." Encryption is a stretch really... It's more of a simple encoding.
by qt_ky
Thu Jun 12, 2014 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split data based on size in datastage
Replies: 7
Views: 2956

The Big Data File stage in 9.1 has an optional Max File Size property for writing target files. When the max size is reached (in MB), it generates another target file. I found this in the documentation; have not tested it myself.
by qt_ky
Thu Jun 12, 2014 3:07 pm
Forum: Site/Forum
Topic: Unable to see premium member's contents after payment
Replies: 2
Views: 6638

Oh, you signed up for a one month membership?

I recently renewed and was made active again within 2 business days.
by qt_ky
Thu Jun 12, 2014 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP - ASCII vs Binary
Replies: 6
Views: 2537

I've not encountered any problems with binary transfers. With ASCII transfers however, I have witnessed a LOT of extra developer time ($$) and effort spent here and there as a result of the various automatic translation "favors." :shock:
by qt_ky
Thu Jun 12, 2014 2:59 pm
Forum: General
Topic: Datastage (Infosphere Information Server) Sizing
Replies: 9
Views: 1636

asorrell wrote:IBM will not be very helpful unless you are going to use AIX systems...
I disagree. I searched some of my past Info Server sizing documents and found AIX was never even mentioned.
by qt_ky
Thu Jun 12, 2014 2:52 pm
Forum: General
Topic: Adding a Datastage Engine to an existing Infosphere Service
Replies: 6
Views: 3544

See the middle of this topic for a sizing estimate process/document description.

See the middle of this topic for a related IBM Redbook link.
by qt_ky
Thu Jun 12, 2014 6:55 am
Forum: General
Topic: DataStage Installation
Replies: 4
Views: 538

Is your client perhaps installed on an unsupported operating system?

Can you get the computer re-imaged (fresh OS install)?
by qt_ky
Wed Jun 11, 2014 7:25 pm
Forum: General
Topic: Adding a Datastage Engine to an existing Infosphere Service
Replies: 6
Views: 3544

Having all 3 server tiers on one computer (default install) is not necessarily bad. Do you know for certain what is causing the bottleneck? If it's a database I/O bottleneck, then investing in additional DataStage servers and PVU licenses may not help your situation much. Many times, job designs can...