Skip to Content
0
Former Member
Dec 24, 2008 at 11:11 AM

Column Activity time of DB2 Thread Activity is sorted improperly

20 Views

Dear Thomas!

There is a small but annoying problem... The column of "Activity Time" in "Thread Activity" ALV table is not sorted properly.

The field of "ACTTIME" contains time amounts in two different formats if the amount includes days or doesn't.

The note 1280173 doesn't correct the problem. Even after this note the column sorted in the descending mode looks in such a way:

12:13:14.156789

099d 12:13:14.5

07:24:34.157890

030d 12:13:14.5

020d 12:13:14.5

01:24:34.157890...

The desired format (even with "d" for days):

d099 12:13:14.5

d030 12:13:14.5

d010 12:13:14.5

12:13:14.156789

07:24:34.157890

01:24:34.157890...

It is an ALV table and its numerical fields are displayed as right-justified and character fields as left-justified despite leading spaces. A correction is required, either in the sorting routine or in these values presentation.

Best regards,

Vlad