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.