Close Command on DB2 Enterprise Stage

[mjgmc]

Hello,

I'd like to run stats after my Load inside the DB2 Enterprise Stage. The problem is that the Database is DB2 DPF (partitionned) but the indexes are global, so if I keep the Stage in Parallel mode and use the option Statistics=stats_all, it aborts with a deadlock from DB2.

I thought to run the stats on the Close Command. But it seems this command is just dismissed, because no matter what I write on it, the job always finishes OK, but the Close Command doesn't run. I even tried to put "toto" inside, and it has the same behaviour.

Can anyone tell me what to do so this command be correctly sent to db2, please?

Thanks.

[John Smith]

think you might need a after job routine to execute to gather the stats.

[mjgmc]

think you might need a after job routine to execute to gather the stats.

Yes, that would be an option if we were allowed to do it. Internal rules : No before/after routines.

[ray.wurlod]

You can't have one, you can't have the other. Tell "them" who imposed this stupid restriction, and use a Routine activity instead.

[Griffin07]

Can you tell me how to use a routine to do a runstats on a DB2 mainframe table. We are in v8 on AIX, and we load a table in DB2 using the zloader stage, but now I need to do a runstats before the next DataStage jobs try and pull data from the table we just laoded.

thanks

[mjgmc]

We opened a case at IBM and they provided us a patch.

Seems to work fine, now.