Home page  
Help >
Thunderbolt Debugging Tools
Version 7.11
Thunderbolt Debugging Tools Thunderbolt Debugging Tools
      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.