HP3000-L Archives

November 2003, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: DBGet on Master with BTREE issue
From:
Travis Howerton <[log in to unmask]>
Reply To:
Travis Howerton <[log in to unmask]>
Date:
Mon, 17 Nov 2003 10:07:34 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (135 lines) 
Stan,
here's a cut-n-paste of the MANAGER.SYS session using the Run
Query.pub.sys;Debug method you suggested. This was done while the other
Query process was doing:

>Find NDC=00000000000

again, NDC is an X12 in an automatic Master, with BTREE indexing on, and
there is no 00000000000 value in that table.

I hope this isn't redundant.

-Travis


/SYS/PUB:run query.pub.sys;debug

DEBUG/iX C.16.01

DEBUG Intrinsic at: 27d.0001c038 ?PROGRAM
$1 ($4d) nmdebug > pin #161;tr,i,d
       PC=a.0017d56c normal_sem_unlock+$10
NM* 0) SP=41853a00 RP=a.006098f4 xm_w_commitrecord+$118
NM  1) SP=418539b8 RP=a.004bbc58 xm_end_user_trans+$1e8
NM  2) SP=418538b8 RP=a.00baed28 tm_ksm_space+$bf0
NM  3) SP=418537f8 RP=a.00c4162c tm_ksamxl+$390
NM  4) SP=41853478 RP=a.00eadb84 FSPACE+$5e4
NM  5) SP=41853378 RP=a.00ead56c ?FSPACE+$8
         export stub: 3d5.00813f64 bti_bcb_get_prior_key+$444
NM  6) SP=418530f8 RP=3d5.00776358 find'last'record_416+$ec
NM  7) SP=41852c38 RP=3d5.00777f6c nmdbfind+$19c4
NM  8) SP=41852bd8 RP=3d5.0070e210 dbfind+$1c0
NM  9) SP=41852808 RP=3d5.0070e024 ?dbfind+$8
         export stub: 27d.000915bc findsearch+$1874
NM  a) SP=41852708 RP=27d.0001d374 EN_dbif+$83c
NM  b) SP=418524e8 RP=27d.0001c23c EX_PROGRAM
NM  c) SP=418522c8 RP=27d.00000000
     (end of NM stack)

$2 ($a1) nmdebug > pin #161;tr,i,d
       PC=a.0049a0e4 xm_r_lock+$28
NM* 0) SP=41853978 RP=a.005e26a8 disc_sm_start_read+$16c
NM  1) SP=418538b8 RP=a.00bae760 tm_ksm_space+$628
NM  2) SP=418537f8 RP=a.00c4162c tm_ksamxl+$390
NM  3) SP=41853478 RP=a.00eadb84 FSPACE+$5e4
NM  4) SP=41853378 RP=a.00ead56c ?FSPACE+$8
         export stub: 3d5.00813f64 bti_bcb_get_prior_key+$444
NM  5) SP=418530f8 RP=3d5.00776358 find'last'record_416+$ec
NM  6) SP=41852c38 RP=3d5.00777f6c nmdbfind+$19c4
NM  7) SP=41852bd8 RP=3d5.0070e210 dbfind+$1c0
NM  8) SP=41852808 RP=3d5.0070e024 ?dbfind+$8
         export stub: 27d.000915bc findsearch+$1874
NM  9) SP=41852708 RP=27d.0001d374 EN_dbif+$83c
NM  a) SP=418524e8 RP=27d.0001c23c EX_PROGRAM
NM  b) SP=418522c8 RP=27d.00000000
     (end of NM stack)

$4 ($a1) nmdebug > pin #161;tr,i,d
       PC=a.00ba6690 tm_ksm_read+$474
NM* 0) SP=418539b8 RP=a.00c41580 tm_ksamxl+$2e4
NM  1) SP=41853638 RP=a.00b1c4ac fread_nm+$83c
NM  2) SP=41853538 RP=a.00eaa5cc FREAD+$d4
NM  3) SP=418531f8 RP=a.00eaa4c4 ?FREAD+$8
         export stub: 3d5.00814090 bti_bcb_get_prior_key+$570
NM  4) SP=418530f8 RP=3d5.00776358 find'last'record_416+$ec
NM  5) SP=41852c38 RP=3d5.00777f6c nmdbfind+$19c4
NM  6) SP=41852bd8 RP=3d5.0070e210 dbfind+$1c0
NM  7) SP=41852808 RP=3d5.0070e024 ?dbfind+$8
         export stub: 27d.000915bc findsearch+$1874
NM  8) SP=41852708 RP=27d.0001d374 EN_dbif+$83c
NM  9) SP=418524e8 RP=27d.0001c23c EX_PROGRAM
NM  a) SP=418522c8 RP=27d.00000000
     (end of NM stack)

$5 ($a1) nmdebug > pin #161;tr,i,d
       PC=a.00c44864 ksm_key_search+$9c
NM* 0) SP=41853978 RP=a.00bae9ac tm_ksm_space+$874
NM  1) SP=418537f8 RP=a.00c4162c tm_ksamxl+$390
NM  2) SP=41853478 RP=a.00eadb84 FSPACE+$5e4
NM  3) SP=41853378 RP=a.00ead56c ?FSPACE+$8
         export stub: 3d5.00813f64 bti_bcb_get_prior_key+$444
NM  4) SP=418530f8 RP=3d5.00776358 find'last'record_416+$ec
NM  5) SP=41852c38 RP=3d5.00777f6c nmdbfind+$19c4
NM  6) SP=41852bd8 RP=3d5.0070e210 dbfind+$1c0
NM  7) SP=41852808 RP=3d5.0070e024 ?dbfind+$8
         export stub: 27d.000915bc findsearch+$1874
NM  8) SP=41852708 RP=27d.0001d374 EN_dbif+$83c
NM  9) SP=418524e8 RP=27d.0001c23c EX_PROGRAM
NM  a) SP=418522c8 RP=27d.00000000
     (end of NM stack)

$6 ($a1) nmdebug > pin #161;tr,i,d
       PC=a.00baf0ec ksm_key_compare+$18
NM* 0) SP=418539b8 RP=a.00c44b34 ksm_key_search+$36c
NM  1) SP=41853978 RP=a.00bae9ac tm_ksm_space+$874
NM  2) SP=418537f8 RP=a.00c4162c tm_ksamxl+$390
NM  3) SP=41853478 RP=a.00eadb84 FSPACE+$5e4
NM  4) SP=41853378 RP=a.00ead56c ?FSPACE+$8
         export stub: 3d5.00813f64 bti_bcb_get_prior_key+$444
NM  5) SP=418530f8 RP=3d5.00776358 find'last'record_416+$ec
NM  6) SP=41852c38 RP=3d5.00777f6c nmdbfind+$19c4
NM  7) SP=41852bd8 RP=3d5.0070e210 dbfind+$1c0
NM  8) SP=41852808 RP=3d5.0070e024 ?dbfind+$8
         export stub: 27d.000915bc findsearch+$1874
NM  9) SP=41852708 RP=27d.0001d374 EN_dbif+$83c
NM  a) SP=418524e8 RP=27d.0001c23c EX_PROGRAM
NM  b) SP=418522c8 RP=27d.00000000
     (end of NM stack)

$7 ($a1) nmdebug > pin #161;tr,i,d
       PC=a.00e9c894 FFILEINFO.nm_process_item+$15fc
NM* 0) SP=41853df8 RP=a.00ea16a0 FFILEINFO+$584
NM  1) SP=41853578 RP=a.00ea10e8 ?FFILEINFO+$8
         export stub: 3d5.008141cc bti_bcb_get_prior_key+$6ac
NM  2) SP=418530f8 RP=3d5.00776358 find'last'record_416+$ec
NM  3) SP=41852c38 RP=3d5.00777f6c nmdbfind+$19c4
NM  4) SP=41852bd8 RP=3d5.0070e210 dbfind+$1c0
NM  5) SP=41852808 RP=3d5.0070e024 ?dbfind+$8
         export stub: 27d.000915bc findsearch+$1874
NM  6) SP=41852708 RP=27d.0001d374 EN_dbif+$83c
NM  7) SP=418524e8 RP=27d.0001c23c EX_PROGRAM
NM  8) SP=418522c8 RP=27d.00000000
     (end of NM stack)

$8 ($a1) nmdebug > c
HP32216N.03.13  QUERY/NM  MON, NOV 17, 2003, 10:01 AM
COPYRIGHT HEWLETT-PACKARD CO. 1976

>e

END OF PROGRAM

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2