[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::repository

Title:	Oracle CDD/Repositorynce
Notice:	Current versions are V7.0-01 and V6.1-03eld Test 3
Moderator:	8292::PJACOBN

Created:	Thu Jan 21 1993
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1094
Total number of notes:	4913

1042.0. "search list logicals & CDO" by M5::JAKUHN (RDB: 34% better than real life) Mon Jan 27 1997 23:11

Here is (yet another) new one on me. I have a customer who is using 
    search lists to do SET DEFAULTS in CDO.  They claimed it worked on the
    VAX but not the new ALPHA they are on. ????
    
    Here is the part I find interesting (full output is at the end of this
    note, I thought i would spare anyone having to read all of it)
    
Welcome to CDO V6.1
The CDD/Repository V6.1 User Interface
Type HELP for help
CDO> set def itf_rec    <------- itf_rec is a search list.
CDO> show default
ITF_REC
    = $1$DKC403:[ITF_PROD.CDD]ITF_TEST    
    = $1$DKC403:[ITF_PROD.CDD]ITF_RECORDS
CDO> show records atdc01_line_items
%CDD-F-NOATTACH, unable to attach to dictionary database
-RDB-F-DB_CORRUPT, database filename is corrupt
-RDMS-F-BADROOTMATCH, root file "$1$DKC403:[ITF_PROD.CDD]CDD$DATABASE.RDB;1" no 
longer has its original name 
"ITF_APL_DEVICE:[CDD]CDD$DATABASE.RDB;1"
    
    
    Am I the only person who has not heard of this? I can understand it 
    not working. I am not sure their claim that it ever worked is correct.
    
    jay
     
    
    
******************************************************************************
SPOCK> sh log itf_apl_device,itf_cdd,itf_rec
   "ITF_APL_DEVICE" = "DISK$DATA1:[ITF_TEST.]" (LNM$PROCESS_TABLE)
        = "DISK$USER:[ITF_PROD.]"
   "ITF_APL_DEVICE" = "DISK$USER:[ITF_PROD.]" (LNM$SYSTEM_TABLE)

   "ITF_CDD" = "DISK$USER:[ITF_PROD.CDD]" (LNM$PROCESS_TABLE)
   "ITF_CDD" = "ITF_APL_DEVICE:[CDD]" (LNM$SYSTEM_TABLE)

   "ITF_REC" = "ITF_CDD:ITF_TEST" (LNM$PROCESS_TABLE)
        = "ITF_CDD:ITF_RECORDS"
SPOCK> deass itf_apl_device
SPOCK> def itf_apl_device disk$data1:[itf_test.]/trans=conceal
SPOCK> cdo
Welcome to CDO V6.1
The CDD/Repository V6.1 User Interface
Type HELP for help
CDO> set def itf_rec
CDO> show default
ITF_REC
    = $1$DKC403:[ITF_PROD.CDD]ITF_TEST
    = $1$DKC403:[ITF_PROD.CDD]ITF_RECORDS
CDO> show records atdc01_line_items
%CDD-F-NOATTACH, unable to attach to dictionary database
-RDB-F-DB_CORRUPT, database filename is corrupt
-RDMS-F-BADROOTMATCH, root file "$1$DKC403:[ITF_PROD.CDD]CDD$DATABASE.RDB;1" no 
longer has its original name 
"ITF_APL_DEVICE:[CDD]CDD$DATABASE.RDB;1"
CDO>  Exit 
SPOCK> def/trans=conceal itf_apl_device
disk$data1:[itf_test.],disk$user:[itf_pr
od.]
%DCL-I-SUPERSEDE, previous value of ITF_APL_DEVICE has been superseded
SPOCK> sh log itf_apl_device
   "ITF_APL_DEVICE" = "DISK$DATA1:[ITF_TEST.]" (LNM$PROCESS_TABLE)
        = "DISK$USER:[ITF_PROD.]"
   "ITF_APL_DEVICE" = "DISK$USER:[ITF_PROD.]" (LNM$SYSTEM_TABLE)
SPOCK> cdo
Welcome to CDO V6.1
The CDD/Repository V6.1 User Interface
Type HELP for help
CDO> set def itf_Rec
CDO> sh default
ITF_REC
    = $1$DKC403:[ITF_PROD.CDD]ITF_TEST
    = $1$DKC403:[ITF_PROD.CDD]ITF_RECORDS
CDO> show record atdc01_line_items
Definition of record ATDC01_LINE_ITEMS
|   Contains field           RECORD_TYPE
|   Contains field           REF_NUM
|   Contains field           PRODUCT
|   Contains field           PROD_DESC_1
|   Contains field           PROD_DESC_2
|   Contains field           ORDER_QTY
|   Contains field           RESERVED_QTY
|   Contains field           UNIT_OF_MEASURE
|   Contains field           FREE_GOODS_IND
                         
CDO>  Exit 
SPOCK> dir itf_cdd

Directory $1$DKC403:[ITF_PROD.CDD]

00000000.30000000;1
                           0/0         1-AUG-1996 15:26:27.48
30000000CDD$PROTOCOLS.40000000;1
                           0/0         1-AUG-1996 15:26:27.45
30000000DENSON.50000000;1
                           0/0        20-DEC-1996 11:42:46.06
30000000DTR$LIB.60000000;1
                           0/0        20-DEC-1996 11:42:46.64
30000000DTR$USERS.70000000;1
                           0/0        20-DEC-1996 11:42:47.17
30000000ITF_BMS.80000000;1
                           0/0        20-DEC-1996 11:42:47.57
30000000ITF_DOMAINS.90000000;1
                           0/0        20-DEC-1996 11:42:48.18
30000000ITF_RECORDS.B0000000;1
                           0/0        20-DEC-1996 11:42:49.21
30000000ITF_TEST.D0000000;1
                           0/0        20-DEC-1996 11:42:50.32
90000000AP62.A0000000;1
                           0/0        20-DEC-1996 11:42:48.67
B0000000AP62.C0000000;1
                           0/0        20-DEC-1996 11:42:49.77
CDD$DATA.RDA;1         14352/14352    20-DEC-1996 11:42:21.54
CDD$DATA.SNP;1           408/408      20-DEC-1996 11:42:39.16
CDD$DATABASE.RDA;1     11000/11004    20-DEC-1996 11:42:21.34
CDD$DATABASE.RDB;1       258/264      20-DEC-1996 11:42:21.05
CDD$DATABASE.SNP;1       588/588      20-DEC-1996 11:42:38.88
CDD$DIRECTORY.CDD;1
                           4/12        1-AUG-1996 15:26:16.28
CONTEXTS.DIR;1             1/12       20-DEC-1996 11:42:19.57
DELTAFILES.DIR;1           1/12       20-DEC-1996 11:42:19.41
PARTITIONS.DIR;1           1/12       20-DEC-1996 11:42:19.72

Total of 20 files, 26613/26664 blocks.

Please note that $1$DKC403 is the same as Disk$User.  Note also that on the 
VAX, Itf_Apl_Device is defined as a concealed process logical,
Disk$Data1:[Itf_Test.], only, as well as a system logical as shown above, and 
it works.  On the ALPHA, I have to define the process logical as a search
logical that includes the system logical definition before it will work.

Thanks for your help.

Phyllis (770) 955-3221 X1112

--=_ORCL_29418114_0_11919701271510160--

================== RFC 822 Headers ==================
Received:  by mailsun3-fddi.us.oracle.com (8.7.5/37.9)
	id OAA04989; Mon, 27 Jan 1997 14:09:16 -0800 (PST)
Message-Id: <199701272209.OAA04989@mailsun3-fddi.us.oracle.com>
Date: 27 Jan 97 14:06:46 -0800
From: "JAKUHN.US.ORACLE.COM" <JAKUHN@us.oracle.com>
To: jakuhn@m5.us.oracle.com
Subject: Fwd: CDO Interpretation on AXP vs. VAX
MIME-Version: 1.0
X-Mailer: Oracle InterOffice (version 4.0.4.0.25)
Content-Type: multipart/mixed; boundary="=_ORCL_29418114_0_11919701271510160"

T.R	Title	User	Personal Name	Date	Lines
1042.1	I need some double checks on VAX	8292::PJACOB	Patrick JACOB-pjacob@fr.oracle.com	`Wed Jan 29 1997 10:55`	40
	Hi Jay, The architecture you described looks complicated to me : - you set your default ( ITF_REC ) to a search list defined in the process table . - ITF_REC logical name uses ITF_CDD logical which is defined differently in 2 tables. In the process table it uses DISK$USER ; in the system table it uses ITF_APL_DEVICE - ITF_APL_DEVICE logical names is defined differently in 2 tables. In the process table it is a search list using 2 logical names DISK$DATA1 and DISK$USER pointing to 2 different repositories. In the system table it uses only DISK$USER logical name to point to only one repository. - I assume here ATDC01_LINE_ITEMS is not a logical name Given this, it works. However, when ITF_APL_DEVICE of the process table points to the TEST repository through DISK$DATA1 it fails complaining with the PROD repository through ITF_APL_DEVICE. RDMS complains because the root file is supposed to be in ITF_APL_DEVICE:[CDD]CDD$DATABASE.RDB;1 and it founds $1$DKC403:[ITF_PROD.CDD]CDD$DATABASE.RDB;1 It looks normal to me because ITF_APL_DEVICE translates to DISK$DATA1:[ITF_TEST.] . I don't know the translation of DISK$DATA1 but anyway since ITF_APL_DEVICE addresses [ITF_TEST.CDD] repository this can't match with [ITF_PROD.CDD] repository. What could be strange is if it works on VAX. There must be something different. A complete set of 1) $ SHOW LOGICAL/FULL of (at least) the 5 logical names 2) CDO> SHOW GENERIC CDD$ANCHOR [ITF_xxxx.CDD]CDD$PROTOCOLS.CDD$SELF 3) $ DUMP/BLOCK=(START=2,COUNT=1) [ITF_*.CDD]CDD$DATABASE.RDB should point to a difference. By the way, what is the Rdb version? Hope this helps. Patrick
1042.2	output	M5::JAKUHN	RDB: 34% better than real life	`Wed Jan 29 1997 22:48`	102
	/The architecture you described looks complicated to me : you got that right! Hi, Following is the output you requested: SPOCK> sh log/ful itf_apl_device,itf_cdd,itf_rec,itf_exe "ITF_APL_DEVICE" [super] = "DISK$DATA3:[BMS_TEST.]" [concealed] (LNM$PROCESS_ TABLE) = "DISK$USER:[ITF_PROD.]" [concealed] "ITF_APL_DEVICE" [exec] = "DISK$USER:[ITF_PROD.]" [concealed] (LNM$SYSTEM_TAB LE) "ITF_CDD" [super] = "DISK$USER:[ITF_PROD.CDD]" (LNM$PROCESS_TABLE) "ITF_CDD" [exec] = "ITF_APL_DEVICE:[CDD]" (LNM$SYSTEM_TABLE) "ITF_REC" [super] = "ITF_CDD:ITF_BMS" (LNM$PROCESS_TABLE) = "ITF_CDD:ITF_RECORDS" "ITF_EXE" [super] = "DISK$DATA3:[BMS_TEST.EXE]" (LNM$PROCESS_TABLE) "ITF_EXE" [exec] = "ITF_APL_DEVICE:[EXE]" (LNM$SYSTEM_TABLE) SPOCK> ! SPOCK> ! Note again, that the Itf_Apl_Device process logical had to be made a se arch SPOCK> !list to get CDO to see the records in both Itf_BMS AND ItfTF_RECORDS. SPOCK> ! SPOCK> ! SPOCK> cdo Welcome to CDO V6.1 The CDD/Repository V6.1 User Interface Type HELP for help CDO> show generic cdd$anchor [itf_prod.cdd]cdd$protocols.cdd$self %CDD-E-FSDNF, file system directory ITF_APL_DEVICE:[ITF_PROD.CDD] not found CDO> show generic cdd$anchor disk$user:[itf_prod.cdd]cdd$protocols.cdd$self Definition of * name is unspecified * (Type : MCS_DATABASE) \| MCS_path ITF_APL_DEVICE:[CDD] \| MCS_node SPOCK:: \| MCS_rootpath CDO> show generic cdd$anchor itf_apl_device:[cdd]cdd$protocols.cdd$self Definition of * name is unspecified * (Type : MCS_DATABASE) \| MCS_path ITF_APL_DEVICE:[CDD] \| MCS_node SPOCK:: \| MCS_rootpath CDO> Exit SPOCK> dump/block=(start=2,count=1) disk$user:[itf_prod.cdd]cdd$database.rdb Dump of file $1$DKC403:[ITF_PROD.CDD]CDD$DATABASE.RDB;1 on 29-JAN-1997 17:58:29. 18 File ID (393,4,0) End of file block 258 / Allocated 264 Virtual block number 2 (00000002), 512 (0200) bytes 00000000 00000000 00000000 00000000 ................ 000000 00000000 00000000 00000000 00000000 ................ 000010 00000000 00000000 00000000 00000000 ................ 000020 00000000 00000000 00000000 00000000 ................ 000030 00000000 00000000 00000000 00000000 ................ 000040 00000000 00000000 00000000 00000000 ................ 000050 00000000 00000000 00000000 00000000 ................ 000060 00000000 00000000 00000000 00000000 ................ 000070 00000000 00000000 00000000 00000000 ................ 000080 00000000 00000000 00000000 00000000 ................ 000090 00000000 00000000 00000000 00000000 ................ 0000A0 00000000 00000000 00000000 00000000 ................ 0000B0 00000000 00000000 00000000 00000000 ................ 0000C0 00000000 00000000 00000000 00000000 ................ 0000D0 00000000 00000000 00000000 00000000 ................ 0000E0 00000000 00000000 00000000 00000000 ................ 0000F0 3A454349 5645445F 4C50415F 46544926 &ITF_APL_DEVICE: 000100 53414241 54414424 4444435D 4444435B [CDD]CDD$DATABAS 000110 00000000 313B4244 52313B42 44522E45 E.RDB;1RDB;1.... 000120 00000000 00000000 00000000 00000000 ................ 000130 00000000 00000000 00000000 00000000 ................ 000140 00000000 00000000 00000000 00000000 ................ 000150 00000000 00000000 00000000 00000000 ................ 000160 00000000 00000000 00000000 00000000 ................ 000170 00000000 00000000 00000000 00000000 ................ 000180 00000000 00000000 00000000 00000000 ................ 000190 00000000 00000000 00000000 00000000 ................ 0001A0 00000000 00000000 00000000 00000000 ................ 0001B0 00000000 00000000 00000000 00000000 ................ 0001C0 00000000 00000000 00000000 00000000 ................ 0001D0 00000000 00000000 00000000 00000000 ................ 0001E0 00000000 00000000 00000000 00000000 ................ 0001F0 SPOCK>
1042.3	some info are still missing	8292::PJACOB	Patrick JACOB-pjacob@fr.oracle.com	`Fri Jan 31 1997 18:36`	74
	Hi Jay, you do not simplify my life! You gave me the translation of ITF_EXE which is useless to me . On the contrary the translation of DISK$DATA3 and DISK$USER is missing when it would help. In addition, ITF_APL_DEVICE now translates to DISK$DATA3:[BMS_TEST.] when it translated to DISK$DATA1:[ITF_TEST.]. I have the VMS dump of DISK$USER:[ITF_PROD.CDD]CDD$DATABASE.RDB but the dump of DISK$DATA3:[BMS_TEST.CDD]CDD$DATABASE.RDB is missing. I have the show generic of disk$user:[itf_prod.cdd]cdd$protocols.cdd$self but the one of disk$data3:[bms_test.cdd]cdd$protocols.cdd$self is missing. Despite of this I tried to reproduce your environment on a VAX machine where it is supposed to work. But I got BADROOTMATCH even when ITF_APL_DEVICE is a search list. I don't know if it is because I did not fill the missing information by something different from your setting, or , if it is because I tested against CDD V7.0. Thus, please, provide all the information I need, or even better, provide a complete script. Patrick. PS: What I am looking for is something like : $ set verify $ set noon $ write sys$output f$getsyi("arch_name") $ define/system disk$data3 FRVMSS$DKA300: $ define/system disk$user FRVMSS$DKA300: $ define/super/process/trans=con - itf_apl_device disk$data3:[bms_test.],disk$user:[itf_prod.] $ define/exec/system/trans=con itf_apl_device disk$user:[itf_prod.] $ define/super/process itf_cdd disk$user:[itf_prod.cdd] $ define/exec/system itf_cdd itf_apl_device:[cdd] $ define/super/process itf_rec itf_cdd:itf_bms,itf_cdd:itf_records $ define/super/process/trans=con itf_apl_device disk$user:[itf_prod.] $ repos opera define repos itf_apl_device:[cdd]. $ repos opera set default disk$user:[itf_prod.cdd] show generic mcs_database disk$user:[itf_prod.cdd]cdd$protocols.cdd$self define directory itf_bms . define directory itf_records . set default itf_apl_device:[cdd]itf_records define field record_type datatype text size 1. define record atdc01_line_items. record_type. end. show record atdc01_line_items set default itf_rec show default show record atdc01_line_items exit $ define/super/process/trans=con itf_apl_device disk$data3:[bms_test.] $ repos opera define repos itf_apl_device:[cdd]. $ dump/block=(start=2,count=1) disk$user:[itf_prod.cdd]cdd$database.rdb $ dump/block=(start=2,count=1) disk$data3:[bms_test.cdd]cdd$database.rdb $ repos opera show generic cdd$anchor disk$data3:[bms_test.cdd]cdd$protocols.cdd$self set default itf_rec show default show record atdc01_line_items exit $ define/super/process/trans=con - itf_apl_device disk$data3:[bms_test.],disk$user:[itf_prod.] $ repos opera show generic cdd$anchor disk$user:[itf_prod.cdd]cdd$protocols.cdd$self show generic cdd$anchor disk$data3:[bms_test.cdd]cdd$protocols.cdd$self show generic cdd$anchor itf_apl_device:[cdd]cdd$protocols.cdd$self set default itf_rec show default show record atdc01_line_items exit $ set noverify
1042.4	Jay gets the gumball machine!	M5::LWILCOX	Chocolate in January!!	`Fri Jan 31 1997 19:03`	19
	<<< Note 1042.3 by 8292::PJACOB "Patrick JACOB-pjacob@fr.oracle.com" >>> -< some info are still missing >- >> you do not simplify my life! >> You gave me the translation of ITF_EXE which is useless to me . On the >> contrary the translation of DISK$DATA3 and DISK$USER is missing when it >> would help. In addition, ITF_APL_DEVICE now translates to >> DISK$DATA3:[BMS_TEST.] when it translated to DISK$DATA1:[ITF_TEST.]. Ya know, that's exactly what all the customers say about Jay!! >> Despite of this I tried to reproduce your environment on a VAX machine >> where it is supposed to work. But I got BADROOTMATCH even when And, he gets the customers to try stuff even when he's supplied them with half-a**ed information and instructions. That's the beauty of having Jay on our team! :-).
1042.5	But...should we care?	M5::JAKUHN	RDB: 34% better than real life	`Sun Feb 02 1997 16:35`	9
	> you do not simplify my life! Customers say this to me all the time. Well, the million dollar question is, is this "supported"? Since I live on earth, I'd not heard of anyone doing this. I would think the concept of a VMS search list logical and database attaches ect. would not mix. jay
1042.6	yes, and at 1 million dollars , I care !	8292::PJACOB	Patrick JACOB-pjacob@fr.oracle.com	`Thu Feb 13 1997 09:52`	9
	Hi Jay, > Well, the million dollar question is, is this "supported"? Yes. On the principle it is supported. For the million dollars I accept check ;-) Patrick
1042.7		M5::LWILCOX	Chocolate in January!!	`Fri Feb 21 1997 12:24`	9
	<<< Note 1042.6 by 8292::PJACOB "Patrick JACOB-pjacob@fr.oracle.com" >>> -< yes, and at 1 million dollars , I care ! >- >> For the million dollars I accept check ;-) You're crazy Patrick, the rest of us only take CASH from Jay! :-).