DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1246 matches
Author Message
 Topic: Issue with asian UTF8 characters loading to Teradat
PaulVL

Replies: 1
Views: 36

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 18, 2018 9:23 am   Subject: Issue with asian UTF8 characters loading to Teradat
I would start with confirming the character set on the table with your TD DBA.

I would then ensure that your TD connector stages are set to that character set.

I would also ensure that your Da ...
 Topic: identifying conductor node in default pool
PaulVL

Replies: 5
Views: 117

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 16, 2018 11:10 am   Subject: identifying conductor node in default pool
Paste your APT config file, change the actual hostnames and paths if you wish.


What are you researching that makes you look for the "conductor" hostname? Are you wondering which host is reading ...
 Topic: istool.sh ExportError:unable to create temporary archive fil
PaulVL

Replies: 3
Views: 147

PostForum: General   Posted: Wed Jul 11, 2018 8:31 am   Subject: istool.sh ExportError:unable to create temporary archive fil
Notice that it said TEMPORARY archive file.

I would look at your uvconfig setting to see where you have tmp paths defined.

See if your user id has rw permission there.

Please paste the full e ...
 Topic: Long time in completion of job, after executing all stages
PaulVL

Replies: 3
Views: 228

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 22, 2018 11:15 am   Subject: Long time in completion of job, after executing all stages
Log message tip of the day:

The timestamp of the entry in the log is not the timestamp of the event happening, it is the timestamp of the actual WRITE to the log of that event.

Think of the log ...
 Topic: DataStage application is running too slow
PaulVL

Replies: 8
Views: 268

PostForum: General   Posted: Fri Jun 22, 2018 7:40 am   Subject: DataStage application is running too slow
So you're the admin and you do not know if you are clustered or grid? hmmm... Look at your APT file. If you see more than one fastname host than you are Cluster. If you use APT_GRID_<anything&g ...
Resolved
 Topic: Error ORA-01461
PaulVL

Replies: 9
Views: 350

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Jun 21, 2018 3:17 pm   Subject: Error ORA-01461
I've got a few migrations under my belt now. The 1# issue encountered is Metadata related. Bad columns in the old job that were "warnings" are now aborts.
 Topic: DataStage application is running too slow
PaulVL

Replies: 8
Views: 268

PostForum: General   Posted: Thu Jun 21, 2018 3:14 pm   Subject: DataStage application is running too slow
I would now say that you need to talk to your DataStage admin to see his take on your "slow" environment.

for pid count, type this at the command line:


ps -ef | wc -l
 Topic: DataStage application is running too slow
PaulVL

Replies: 8
Views: 268

PostForum: General   Posted: Thu Jun 21, 2018 8:04 am   Subject: DataStage application is running too slow
Are you running on a physical host or a Virtual machine?

How many PIDs are running on the host?

Is it a stand alone setup or a Cluster/Grid?

NAS or SAN mounts?
 Topic: Schemas for flat files and datasets
PaulVL

Replies: 2
Views: 183

PostForum: General   Posted: Fri Jun 01, 2018 12:17 pm   Subject: Schemas for flat files and datasets
You can filter out the schema file from a dataset like this:

Put this into a sequencer execute stage.


echo "record" > #seqfilepath##ds_filename#.schema; echo "{record_delim='\n', final_deli ...
 Topic: performance data
PaulVL

Replies: 4
Views: 345

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 31, 2018 12:41 pm   Subject: performance data
any reason you are not using the data that is collected automatically in the DSODB database?
 Topic: error while loading db2
PaulVL

Replies: 7
Views: 532

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 29, 2018 8:40 am   Subject: error while loading db2
And what path would that be that the named pipe is using?

I believe it would be using whatever is defined in the TMPDIR project variable.

Are you sure that your APT file which may be using other ...
 Topic: pxbridge error
PaulVL

Replies: 2
Views: 256

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 28, 2018 5:36 am   Subject: pxbridge error
Do a diff on your previous .odbc.ini and the new one.
Resolved
 Topic: Failed to load the library
PaulVL

Replies: 5
Views: 439

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 28, 2018 5:34 am   Subject: Failed to load the library
Did you do a Force Compile?

Maybe it can't find stdio.h ?
 Topic: Recorded videos for learning
PaulVL

Replies: 9
Views: 395

PostForum: General   Posted: Wed May 23, 2018 6:45 am   Subject: Recorded videos for learning
How about you type DataStage in Youtube and go look there?
 Topic: lost discussion
PaulVL

Replies: 4
Views: 296

PostForum: General   Posted: Wed May 16, 2018 10:23 am   Subject: lost discussion
What was the topic?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours