Search found 45 matches

by yimwai
Sun Jul 02, 2017 8:47 pm
Forum: General
Topic: The client session to the service tier is lost
Replies: 3
Views: 3987

The client session to the service tier is lost

Everytime when I login Director in windows to connect to remote server 11.3 on unix, will be promted "The client session to the service Tier is lost .Attempting to re-establish session", the window will show again if I tried to close it.
What's the issue and how to resolve it?
by yimwai
Fri Nov 13, 2015 1:45 am
Forum: General
Topic: Export the new updated items automatically
Replies: 3
Views: 2019

Export the new updated items automatically

We want to use a daily run crontab job to export the new updated item within a day.
Is there any options for export command to export such items?
by yimwai
Fri Nov 06, 2015 8:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to avoid backup pending tablespaces
Replies: 3
Views: 4129

How to avoid backup pending tablespaces

We use connector to load data,
Bulk load write mode and append

When the job runs, the table space will become Backup pending
How to avoid this
by yimwai
Tue Nov 03, 2015 11:30 pm
Forum: General
Topic: Export latest updated jobs and other items
Replies: 2
Views: 1581

Thank you so much.
And can we use command line, shell script to do such export?
by yimwai
Tue Nov 03, 2015 7:24 pm
Forum: General
Topic: Export latest updated jobs and other items
Replies: 2
Views: 1581

Export latest updated jobs and other items

Is it possible to export all the jobs ,table definitions and other items which were created or updated after a specific day?
by yimwai
Tue Sep 01, 2015 7:05 am
Forum: General
Topic: Sending email per records
Replies: 4
Views: 1887

I can not view your words after easiest using....
because the number of mails will not be more than 10, thus we don't want to have another application or script. could you please directly tell me which stages can be used?
by yimwai
Tue Sep 01, 2015 3:53 am
Forum: General
Topic: Sending email per records
Replies: 4
Views: 1887

Sending email per records

A new requirement is to send emails to different persons according to the records in one table updated by other application. suppose the table has only 3 fields:receiver,content,issent we need to query all the record with issent 'N' and send email for each record the receiver is in column 'receiver'...
by yimwai
Tue Jun 16, 2015 2:36 am
Forum: General
Topic: performance monitoring
Replies: 3
Views: 2026

performance monitoring

is there any way to fetch all the run logs of all the jobs with a project. is there any way to fetch all the workload of each stage within the job. The mainly information I need are: 1.start/end time 2.elapsed time 3.rows/sec 4.number of rows The information is very similar with what we see from Dir...
by yimwai
Thu Mar 19, 2015 9:16 pm
Forum: General
Topic: How to export every job in the project(one xml per job)
Replies: 1
Views: 1497

How to export every job in the project(one xml per job)

Is there any way to export all the jobs not into one single file,but rather one xml file per job,and the xml file can be put in the same directory as the job's location in the designer.
by yimwai
Thu Feb 05, 2015 1:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to upgrade JVM version of DATASTAGE
Replies: 0
Views: 1572

How to upgrade JVM version of DATASTAGE

I'm using the java integration stage.it use jvm 1.6 to run the java class but the class is compiled with java 1.7.So error is "Unsupported major.minor version"
So my question is how to switch to other jvm, not the built-in one.
by yimwai
Mon Jan 26, 2015 7:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to save image files into Database
Replies: 2
Views: 2036

How to save image files into Database

how to store the image files into blob( or other) column in database
by yimwai
Fri Sep 26, 2014 9:19 am
Forum: General
Topic: Failed to connect to Information Server Engine
Replies: 1
Views: 3044

Failed to connect to Information Server Engine

I have a remote Windows 2008 box which Information server 9.1 is installed. I can open designer at that server successfully. when I installed the client on my local. When I login to designer.I can select project when I fill the host,username and password. but when I click the login button, it run in...
by yimwai
Mon Sep 24, 2012 8:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: precision problem from sequential file to DB2
Replies: 4
Views: 2400

i use varchar to read the file and use StringtoDecimal Function, partly solve the problem.
but in file there is some data with scientific notation such as 2.34567E-2.
varchar cannot help
by yimwai
Sun Sep 23, 2012 6:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: precision problem from sequential file to DB2
Replies: 4
Views: 2400

precision problem from sequential file to DB2

source data:sequential file
source value:2324.6199999999999
destination database: db2
data type :decimal(23,10)

We use float datatype to read the file and transform it to decimal(23,10), then the value in the db is 2324.6201171875
why?
how can i make the db2 value is also 2324.6199999999
by yimwai
Mon Jul 04, 2011 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to handle the escape code in sequential file stage
Replies: 2
Views: 1849

how to handle the escape code in sequential file stage

I use a sequential stage to read a DB2 exported file . one record only has two columns one is id (int),the other is name(char(60)) but sometime there will be a " in the second column, after exported,there will be double " in the file,one is the escape code. so in this time how can i read t...