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 --------+ ------------------------------

The IBM onstat -g dic image is a direct lift from our site :-)