Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g ppd Partition Compression Dictionary Information

The onstat -g ppd command displays information about the active compression dictionaries. 

Partition Compression Dictionary Info
partnum    Version  DbsNum  CrTS       CrLogID  CrLogPos  DrTS   DrLogID  DrLogPos
0x200002   1        2       1229018150   3        577560    0      0        0        
0x200003   1        2       1229018150   3        606232    0      0        0        
0x300002   1        3       1229018150   3        630808    0      0        0        
0x400002   1        4       1229018150   3        655384    0      0        0        
0x500002   1        5       1229018150   3        679960    0      0        0

Output Description

Option Description
partnum Partition number to which the compression dictionary applies
Version Version of the code that is creating the compression dictionary
DbsNum Number of the dbspace that the dictionary resides in
CrTS Timestamp that shows when the dictionary was created
CrLogID Unique ID for the logical log that was created when the dictionary was created
CrLogPos Position within the logical log when the dictionary was created
DrTS Timestamp that shows when the dictionary was purged
DrLogID Unique ID for the logical log that was created when the dictionary was purged
DrLogPos Position within the logical log when the dictionary was purged

Notes

  • The onstat -g ppd only show active dictionaries, to see all dictionaries use the syscompdicts_full table and the syscompdicts view

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.