1.0 DEBUG/F - display open file info 2.0 DEBUG/L - display lock status 3.0 DEBUG/C - display collection info 4.0 DEBUG/G - display shared memory block and trigger info 5.0 DEBUG/H - display .mmm available block list 6.0 DEBUG/I <TableName> - print cluster stack 7.0 DEBUG/N - print Name Tables 8.0 DEBUG/P <cx> [<tablename>] - print sort file contents 9.0 DEBUG/K - print token map tables 10.0 DEBUG/T <KeyName> - tree efficiency analysis 11.0 DEBUG/V <ValueString> <type1> <type2> ... <typeN> 12.0 SHOW/F[L][N] <keyname> <block#> ... 13.0 SHOW/V 14.0 SHOW <keyname> <value> 15.0 TALLY/V 16.0 INFO/V 17.0 INFO/T - reconstruct symbolic .dbd 18.0 DBD COMP/M - Produce File Map 19.0 EXTRA COLLECTIONS ARE - collection names and attributes 20.0 PON/F 21.0 MODE DEBUG 7 22.0 MODE TRACE ON/OFF 23.0 CalcObject DEBUG Statement 24.0 DdPrint.log 25.0 System Error Log 26.0 DDTL MBM Command - collection and structure diagnostic In ddtl, use the DEBUG command. In TB API, use the ddlDebug() function. 1.0 DEBUG/F - display open file info >debug/f 2.0 DEBUG/L - display lock status >debug/l 3.0 DEBUG/C - display collection info >debug/c Collection file is C:\temp\NSTO1.CCC; block size is 3276 ^R 000400 CUSTOMERS 000400-00043f Type = Raw nchar0 =32768 IN=00 INVENTORY 000440-000447 Type = Raw nchar0 =32704 IN=00 SALES 000448-0005bf Type = Raw nchar0 =32696 IN=00 SALES2 0005c0-000737 Type = Raw nchar0 =32320 IN=00 STATES 000738-000747 Type = Raw nchar0 =31944 IN=00 CLIENTS 000748-000757 Type = Raw nchar0 =31928 IN=00 CUSTVIRT 000758-000767 Type = Raw nchar0 =31912 IN=00 TEST 000768-001fd3 Type = Raw nchar0 =31896 IN=00 XTEMP 001fd4-002053 Type = Raw nchar0 =25644 IN=00 IMAGES 002054-005127 Type = Raw nchar0 =25516 IN=00 ^S 000000 CUSTOMERS 000000-00003f Type = Bitmap nchar0 =32768 IN=01 INVENTORY 000000-000007 Type = Bitmap nchar0 =32768 IN=01 SALES 000000-000177 Type = Bitmap nchar0 =32768 IN=01 SALES2 000000-000177 Type = Bitmap nchar0 =32768 IN=01 STATES 000000-00000f Type = Bitmap nchar0 =32768 IN=01 CLIENTS 000000-00000f Type = Bitmap nchar0 =32768 IN=01 CUSTVIRT 000000-00000f Type = Bitmap nchar0 =32768 IN=01 TEST 000000-00186b Type = Bitmap nchar0 =32768 IN=01 XTEMP 000000-00007f Type = Bitmap nchar0 =32768 IN=01 IMAGES 000000-0030d3 Type = Bitmap nchar0 =32768 IN=01 4.0 DEBUG/G - display shared memory block and trigger info 5.0 DEBUG/H - display .mmm available block list 6.0 DEBUG/I <TableName> - print cluster stack >debug/i t1 Table: T1 DGT1 c: 26 l: 0 S: 8 L: 49 T: 1 K: 0 F:0000 C:0000 f: T1C12 c: 27 l: 1 S: 8 L: 8 T: 6 K:12472 F:0000 C:0000 f: T1_TBROWID_S c: 28 l: 1 S: 16 L: 11 T: 1 K:12740 F:0000 C:0000 f: T1C7 c: 29 l: 1 S: 27 L: 11 T: 1 K:13008 F:4000 C:0000 f:v T1_TBROWID c: 30 l: 1 S: 38 L: 5 T: 1 K:13276 F:0000 C:0000 f: T1C6 c: 31 l: 1 S: 43 L: 5 T: 1 K:13544 F:4000 C:0000 f:v T1C1 c: 32 l: 1 S: 48 L: 9 T: 1 K:13812 F:0000 C:0000 f: Table: T1 True DGT1 c: 26 l: 0 S: 8 L: 33 T: 1 K: 0 F:0000 C:0000 f: T1C12 c: 27 l: 1 S: 8 L: 8 T: 6 K:12472 F:0000 C:0000 f: T1_TBROWID_S c: 28 l: 1 S: 16 L: 11 T: 1 K:12740 F:0000 C:0000 f: T1_TBROWID c: 30 l: 1 S: 27 L: 5 T: 1 K:13276 F:0000 C:0000 f: T1C1 c: 32 l: 1 S: 32 L: 9 T: 1 K:13812 F:0000 C:0000 f: c: compressed name l: level S: stp L: length T: type K: key pointer F: flags C: codes f: flags as string (p & v only) A: alias 7.0 DEBUG/N - print Name Tables Table ID List count: 20 size: 100 mem: 7200 length: 64 1 CUSTOMERS 2 INVENTORY 3 SALES 4 SALES2 5 STATES 6 CUSTVIRT 7 INVVIRT 8 SALESVIRT 9 TEST 10 TEST2 11 XTEMP 12 GROWTEMP 13 CLIENTS 14 KS 15 LARGE 16 LARGE2 17 GT2 18 XTEMP_A 19 GTEMP_A 20 GT2_A Table Name List: 13 CLIENTS 1 CUSTOMERS 6 CUSTVIRT 12 GROWTEMP 17 GT2 20 GT2_A 19 GTEMP_A 2 INVENTORY 7 INVVIRT 14 KS 15 LARGE 16 LARGE2 3 SALES 4 SALES2 8 SALESVIRT 5 STATES 9 TEST 10 TEST2 11 XTEMP 18 XTEMP_A 9.0 DEBUG/K - print token map tables 10.0 DEBUG/T <KeyName> - tree efficiency analysis Cell Histogram for SESSION.ttt; 1 46 0 0 1 0 0 0 0 0 0 0 30 15 46 0 0 0 0 0 0 0 1 14 0 97 685 46 0 0 0 0 0 0 1 0 684 0 97 31499 35 0 0 0 0 1 0 31498 0 0 0 97 Cell Histogram for RtlSESSION.ttt; 1 8 0 0 0 0 0 0 0 0 0 0 0 11.0 DEBUG/V <ValueString> <type1> <type2> ... <typeN> Move test. <ValueString> contains the source value <type1> is ignored <type2> ... <typeN> are the successive destination types 3 - Short Int (16 bit) 4 - Long Int (32 bit) 5 - Single Float 6 - Double Float 7 - 64 bit Long Int 8 - Logical 9 - Unsigned Long (32 bit) 13 - Date (default template mm/dd/yyyy) 15 - DateTime Alpha (Default template mm/dd/yyyy hh:nn:ss.ttt) 19 - DateTime Bin 12.0 SHOW/F[L][N] <keyname> <block#> ... Show internal cell parameters for .ttt, .lll and .rtl files SHOW/F <keyname> 0 This is the minimum command requirement. It displays the internal cell parameters for cell 0 of the .ttt file [for <keyname>], and the .rtl file, if applicable. SHOW/FN <keyname> 0 Also display nodes within this cell SHOW/FL <keyname> 0 Also display internal cell parameters for .lll file 13.0 SHOW/V 14.0 SHOW <keyname> <value> 15.0 TALLY/V Collection B BIRTHS 99000 records+ C=0 N=0 M=14057448 H= 0 [] [1875000] BIRTHTOTALS 99000 records+ C=0 N=0 M=347407 H= 0 [] [62500] BIRTHMINI 2333 records* C=0 N=1 M=3333 H= 0 [4000] [] BIRTHTOTALTEMP 0 records+ C=0 N=0 M= 0 H= 0 [] [62500] MINIBIRTHRESULTS 0 records+ C=0 N=0 M= 537 H= 0 [] [628] Total 200333 records C=0 N=0 M= 0 H= 0 [] [] C: RppIsClear bit N: RppNeedsClear bit M: MCR H: MaxRec (for GROWable table) [nnnn]: Mem Coll bytes allocated (List) [nnnn]: MBM Coll bytes allocated (Bitmap) 16.0 INFO/V 17.0 INFO/T - reconstruct symbolic .dbd 18.0 DBD COMP/M - Produce File Map File: ONADB.DDD DRL: Lock: 000200 (0200) Data: 000400 (7400) Pad: 007800 (000200) Table: OLEDBSYSTBL Lock: 007A00 (0200) MCR: 007C00 (0200) Data: 007E00 (001000) Table: ETL#_MAPPEDCOLUMNS Lock: 008E00 (0200) MCR: 009000 (0200) Data: 009200 (0AB000) Table: ETL#_ERMAPPINGS Lock: 0B4200 (0200) MCR: 0B4400 (0200) Data: 0B4600 (156000) Table: T73 Lock: 20A600 (0200) MCR: 20A800 (0200) Data: 20AA00 (052000) Table: T72 Lock: 25CA00 (0200) MCR: 25CC00 (0200) Data: 25CE00 (052000) Table: T37 Lock: 2AEE00 (0200) MCR: 2AF000 (0200) Data: 2AF200 (052000) Table: T81 Lock: 301200 (0200) MCR: 301400 (0200) Data: 301600 (052000) Table: T74 Lock: 353600 (0200) MCR: 353800 (0200) Data: 353A00 (07B000) Table: T27 Lock: 3CEA00 (0200) MCR: 3CEC00 (0200) Data: 3CEE00 (052000) Table: T78 Lock: 420E00 (0200) MCR: 421000 (0200) Data: 421200 (052000) Table: T83 Lock: 473200 (0200) MCR: 473400 (0200) Data: 473600 (052000) Table: T80 Lock: 4C5600 (0200) MCR: 4C5800 (0200) Data: 4C5A00 (0B9000) Table: T79 Lock: 57EA00 (0200) MCR: 57EC00 (0200) Data: 57EE00 (052000) Table: T84 Lock: 5D0E00 (0200) MCR: 5D1000 (0200) Data: 5D1200 (066000) Table: T20 Lock: 637200 (0200) MCR: 637400 (0200) Data: 637600 (01E000) File: ONADB.TTT Field: ETL#_TABLENAME Lock: 00C400 (0200) Data: 00C600 (05E000) Field: ETL#_COLUMNNAME Lock: 06A600 (0200) Data: 06A800 (05E000) Field: ETL#_INDEXTABLENAME Lock: 0C8800 (0200) Data: 0C8A00 (012000) Field: ETL#_INDEXCOLUMNNAME Lock: 0DAA00 (0200) Data: 0DAC00 (012000) Field: ETL#_PKTABLENAME Lock: 0ECC00 (0200) Data: 0ECE00 (05E000) etc File: ONADB.LLL Field: ETL#_TABLENAME US: 000200 (1000) Thread: 001200 (008000) Field: ETL#_COLUMNNAME US: 009200 (1000) Thread: 00A200 (008000) Field: ETL#_INDEXTABLENAME US: 012200 (1000) Thread: 013200 (008000) Field: ETL#_INDEXCOLUMNNAME US: 01B200 (1000) Thread: 01C200 (008000) Field: ETL#_PKTABLENAME US: 024200 (1000) Thread: 025200 (008000) Field: ETL#_PKCOLUMNNAME US: 02D200 (1000) Thread: 02E200 (008000) Field: ETL#_FKTABLENAME US: 036200 (1000) Thread: 037200 (008000) Field: ETL#_FKCOLUMNNAME US: 03F200 (1000) Thread: 040200 (008000) Field: T73C4 US: 000400 (1000) Thread: 001400 (018000) [Discrete] Field: T73C3 US: 000400 (1000) Thread: 001400 (018000) [Discrete] Field: T73C2 US: 000400 (1000) Thread: 001400 (018000) [Discrete] etc Table: <TableName> Lock: <addr of locking sector[hex]> (<size of locking sector[hex]>) MCR: <addr of table state info[hex]> (<size of table state info[hex]>) Data: <addr of data space[hex]> (<size of data space[hex]>) 19.0 EXTRA COLLECTIONS ARE - collection names and attributes . The 7 default user collections are {A, B, C, D, E, U, V}; the default collections {B, C, D, E, U, V} can be deleted by prepending '-' to the collection name; for example: EXTRA COLLECTIONS ARE -c -d -e . The 4 default system collections are {^R, ^S, ^T, ^U}; they can also be deleted as above; however, this is not recommended unless the user is fully aware of the consequences of doing so; . Additional collections can be defined by specifying additional names; for example: EXTRA COLLECTIONS ARE cnew dnew enew . The mode for default collections [except ^R] is MEMCOLL [memory based 32 bit integer list], changing to MBM [memory based bitmap] if circumstances require. The mode of an existing collection or of a newly minted collection can be changed by prepending one of the following modifier strings to the collection name: * Raw collection; i.e., file based bitmap; ! No MEMCOLL; i.e., MBM only *! No MEMCOLL; i.e., raw collection only, no integer list; 20.0 PON/F 21.0 MODE DEBUG 7 Enable I/O trace to WhamDiag . 0x01 - file lock trace . 0x02 - file lock advisory . 0x04 - all file I/O trace (except lock) . 0x08 - buffer manager trace 22.0 MODE TRACE ON/OFF . TB RAD - list procedure commands; . TB API - write command info to .log file and/or WhamDiag 24.0 DdPrint.log . MaHalt() code 25.0 System Error Log
Copyright © 2019 , WhamTech, Inc. All rights reserved. This
document is provided for information purposes only and the contents hereof are
subject to change without notice. Names may be
trademarks of their respective owners.