Greetings, Family.

As a curiosity, and to follow up on a Perl script I never got around to writing, I wanted to see the output of onstat -g opn (open tables/partitions).

The printed (PDF) manual on 12.10 (P 20-121 or 587) gives a format and explanation that could be helpful and looks pretty much like Paul Watson's description in his fabulous reference page.

HOWEVER

Both sources are kinda out of date.  The current output has additional columns and is broken down by rstcb/tid i.e. which thread has which tables open. Samples:

rstcb 18239caf8 tid 343
isfd  op_mode    op_flags   partnum    ucnt ocnt lk ra   partp          ocnt ucnt
0     70000      403        f0054f     1    0       0    18c2b1638      0    74
1     70000      403        f0014c     1    0       0    18c09e028      0    125
2     70000      403        2020e3     1    0       0    187ddc720      0    21
3     70000      403        6005b8     1    0       0    1840e5028      0    46
...

rstcb 1823abc48 tid 4590
isfd  op_mode    op_flags   partnum    ucnt ocnt lk ra   partp          ocnt ucnt
0     400        291        1800077    2    2       61   18d2966d0      4    4
1     2          3          1800077    2    2       0    18d2966d0      4    4
2     400        297        100003     2    2    S  61   184319028      464  464
3     2          3          100003     2    2    S  0    184319028      464  464
4     1000400    7          1800053    1    1    S  1    18747f028      1    1
5     1000440    297        1800054    1    1    S  0    18747f690      1    1
6     1000400    413        1800044    3    0    X  1    1873ab028      0    6

and so on.  Very information-rich output but not as helpful without explanation of the columns and flags. (And it does not hep that op_flags is given in decimal rather than hex.)  However, the on-line documentation has gone miserly: used by IBM® Software Support.

Anyone out there who can post the current meanings of all that? Like what each flag means (in Rel 12 and 14) and what is that partp column, as opposed to partnum?

As it stands, I think I have enough up there to "join" the about output with onstat -u and my own old queries that match partnum to database:table (fragments.sh and the like, published years ago in the software repository).   But if I have the opportunity to provide enhanced information I would go for it.  And I will be checking sysmaster.sql for some aspects of this.

On behalf of the knowledge-thirsty IIUG community,

Thanks much!

------------------------------
+-----------------------------------------------------------+
| I am pleased to report that I had no problems today. |
| I had only issues, opportunities, challenges and valuable |
| learning experiences. |
+------------------------------------------ Jacob S --------+
------------------------------

Original Message:
Sent: 1/16/2026 10:27:00 AM
From: Jacob Salomon
Subject: onstat -g opn does not match published documentation

Greetings, Family.

As a curiosity, and to follow up on a Perl script I never got around to writing, I wanted to see the output of onstat -g opn (open tables/partitions).

The printed (PDF) manual on 12.10 (P 20-121 or 587) gives a format and explanation that could be helpful and looks pretty much like Paul Watson's description in his fabulous reference page.

HOWEVER

Both sources are kinda out of date.  The current output has additional columns and is broken down by rstcb/tid i.e. which thread has which tables open. Samples:

rstcb 18239caf8 tid 343
isfd  op_mode    op_flags   partnum    ucnt ocnt lk ra   partp          ocnt ucnt
0     70000      403        f0054f     1    0       0    18c2b1638      0    74
1     70000      403        f0014c     1    0       0    18c09e028      0    125
2     70000      403        2020e3     1    0       0    187ddc720      0    21
3     70000      403        6005b8     1    0       0    1840e5028      0    46
...

rstcb 1823abc48 tid 4590
isfd  op_mode    op_flags   partnum    ucnt ocnt lk ra   partp          ocnt ucnt
0     400        291        1800077    2    2       61   18d2966d0      4    4
1     2          3          1800077    2    2       0    18d2966d0      4    4
2     400        297        100003     2    2    S  61   184319028      464  464
3     2          3          100003     2    2    S  0    184319028      464  464
4     1000400    7          1800053    1    1    S  1    18747f028      1    1
5     1000440    297        1800054    1    1    S  0    18747f690      1    1
6     1000400    413        1800044    3    0    X  1    1873ab028      0    6

and so on.  Very information-rich output but not as helpful without explanation of the columns and flags. (And it does not hep that op_flags is given in decimal rather than hex.)  However, the on-line documentation has gone miserly: used by IBM® Software Support.

Anyone out there who can post the current meanings of all that? Like what each flag means (in Rel 12 and 14) and what is that partp column, as opposed to partnum?

As it stands, I think I have enough up there to "join" the about output with onstat -u and my own old queries that match partnum to database:table (fragments.sh and the like, published years ago in the software repository).   But if I have the opportunity to provide enhanced information I would go for it.  And I will be checking sysmaster.sql for some aspects of this.

On behalf of the knowledge-thirsty IIUG community,

Thanks much!

------------------------------
+-----------------------------------------------------------+
| I am pleased to report that I had no problems today. |
| I had only issues, opportunities, challenges and valuable |
| learning experiences. |
+------------------------------------------ Jacob S --------+
------------------------------