DB2 export tracking

[Former Member]

Hi All,

I was trying to export single table out of DB6 database. The question i had was that how do i monitor how much percentage of the job has completed.

Everytime taking a snapshot would be unrealistic. Do the figures in DB2top for the agent id indicate the number of records that have been exported?

We are trying to export the data from a single table, DB6 version 10.5 FP 3.

[Former Member · Accepted solution]

Hi,

Unfortunately there isn't any other way to track this.

As far as I know the only way is to have snapshot of agentid. You can have this running in a script to get the required data.

And yes the details in snapshot are related to export/import records figures.

Regards,

Prithviraj

[Former Member · Accepted solution]

How about getting to know which temp tablespace R3load is currently using?