AGGREGATION FIELDS field (ACCUMUID subsystem parameter)
The ACCUMUID subsystem parameter determines the aggregation fields that are to be used for DDF and RRSAF accounting rollup.
Acceptable values: | 0–17 |
---|---|
Default: | 0 |
Update: | option 23 on panel DSNTIPB |
DSNZPxxx: | DSN6SYSP ACCUMUID |
The values are defined in the following table.
Value | Rollup criteria | String of X'00' or string of X'40' considered for rollup? |
---|---|---|
0 | User ID, application name or transaction name, and workstation name | Yes1 |
1 | User ID | No |
2 | User application name or transaction name | No |
3 | User workstation name | No |
4 | User ID and application name or transaction name | Yes1 |
5 | User ID and workstation name | Yes1 |
6 | User application name or transaction name and workstation name | Yes1 |
7 | User ID, application name or transaction name, and workstation name | No |
8 | User ID and application name or transaction name | No |
9 | User ID and workstation name | No |
10 | User application name or transaction name and workstation name | No |
11 | User ID, application name or transaction name, and workstation name | Yes |
12 | User ID | Yes |
13 | User application name or transaction name | Yes |
14 | User workstation name | Yes |
15 | User ID and application name or transaction name | Yes |
16 | User ID and workstation name | Yes |
17 | User application name or transaction name and workstation name | Yes |
Note:
|
For example, if a thread has the user ID set to a string of X'00' and the workstation name set to myws, the thread qualifies for rollup if ACCUMUID is set to 5, but not if ACCUMUID is set to 9.
Assume that ACCUMUID is set to 5. The threads in the following table all qualify for rollup.
User ID | Workstation name |
---|---|
myuser | myws |
myuser | A string of X'40' |
A string of X'40' | myws |
myuser | A string of X'00' |
A string of X'00' | myws |
The thread with user ID set to myuser and workstation name set to a string of X'40' and the thread with user ID set to myuser and workstation name set to a string or X'00' are included in the same rollup record. The thread with user ID set to a string of X'40' and workstation name set to myws and the thread with user ID set to a string of X'00' and workstation name set to myws are included in the same rollup record.
Db2 writes individual accounting threads for threads that do not meet the criteria for rollup.
The value of ACCUMUID is ignored if the value of ACCUMACC is set to NO.