Datastage 11.3 version slowly

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
topdsx
Participant
Posts: 9
Joined: Thu Feb 02, 2017 9:36 am

Datastage 11.3 version slowly

Post by topdsx »

Hi,

We migrated Datastage 8.1 towards 11.3 there is 2 weeks and we meet performances slow in server since this night.

I see with unix command: top, no process consumed CPU.

You can see in below:

14826 root 20 0 553m 20m 8296 S 1.6 0.0 3701:14 BESClient
46519 dsadm 20 0 201m 1764 1492 S 1.6 0.0 9:54.65 ResTrackApp
120004 root 20 0 16064 2276 928 R 1.6 0.0 0:05.61 top
298 root 20 0 0 0 0 S 0.7 0.0 2098:41 kblockd/0
11463 root -99 -18 55032 7384 1708 S 0.7 0.0 158:12.46 seosd
28629 oracle -2 0 3417m 16m 16m S 0.7 0.0 3137:10 ora_vktm_p07736
28711 oracle 20 0 3455m 377m 363m S 0.7 0.3 753:12.76 ora_mmon_p07736
43491 root 20 0 7356m 73m 10m S 0.7 0.1 18:50.93 java
44587 dsadm 20 0 175m 3392 2868 S 0.7 0.0 23:40.89 resource_tracke
322 root 20 0 0 0 0 S 0.3 0.0 270:32.61 kblockd/24
3468 root 20 0 5461m 117m 3408 S 0.3 0.1 254:06.19 cybAgent.bin
10385 root 20 0 180m 26m 19m S 0.3 0.0 0:00.01 dsapi_slave
28036 root 20 0 106m 2016 744 S 0.3 0.0 0:03.81 bash
28687 oracle 20 0 3418m 47m 46m S 0.3 0.0 88:00.15 ora_lgwr_p07736
29185 oracle 20 0 3417m 15m 15m S 0.3 0.0 4:11.96 ora_p027_p07736
91620 oracle 20 0 8294m 330m 3232 S 0.3 0.3 27:41.51 java


Have you got an idea please ?

Thanks a lot.

Regards,

DEMBA
DEMBA
topdsx
Participant
Posts: 9
Joined: Thu Feb 02, 2017 9:36 am

Re: Datastage 11.3 version slowly

Post by topdsx »

I add that to open Project_sequece_name file, he took around 3 hours.

How it can work that ?

Regards,

DEMBA
DEMBA
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Hard for us to armchair quarterback this issue for you. There are sooo many factors at play.

As an admin I would ask this question...

During the migration, did you simply copy the DSParms from the old environment projects to the new ones? Or did you simply move the user defined entries?
Post Reply