Record layout UCX database

[Willem Grooters]

Can anyone deliver the record structures of the UCX database files (SYS$SYSTEM:UCX$*.DAT on VMS 6.2, UCX 4.2)?

Willem

[Himanshu_3]

Hi Willem,

Do you want below......

Directory SYS$COMMON:[SYSEXE]

UCX$CONFIGURATION.DAT;1
92
UCX$HOST.DAT;1 80
UCX$NETWORK.DAT;1 80
UCX$PROXY.DAT;1 268
UCX$ROUTE.DAT;1 96
UCX$SERVICE.DAT;1 88

Directory SYS$COMMON:[SYSEXE]

UCX$CONFIGURATION.DAT;1

File organization: Indexed, Prolog: 3, Using 1 key
In 2 areas
Shelved state: Online
File attributes: Allocation: 99, Extend: 17, Maximum bucket size: 17, Global buffer count: 0, No version limit
Contiguous best try
Record format: Variable length, maximum 7680 bytes, longest 0 bytes
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RE, World:RE
Access Cntrl List: None

UCX$HOST.DAT;1

Recording:
File organization: Indexed, Prolog: 3, Using 2 keys
In 3 areas
Shelved state: Online
File attributes: Allocation: 81, Extend: 12, Maximum bucket size: 6, Global buffer count: 0, No version limit
Contiguous best try
Record format: Variable length, maximum 271 bytes, longest 0 bytes
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RE, World:RE
Access Cntrl List: None

UCX$NETWORK.DAT;1

File organization: Indexed, Prolog: 3, Using 2 keys
In 3 areas
Shelved state: Online
File attributes: Allocation: 81, Extend: 12, Maximum bucket size: 6, Global buffer count: 0, No version limit
Contiguous best try
Record format: Variable length, maximum 271 bytes, longest 0 bytes
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RE, World:RE
Access Cntrl List: None

UCX$PROXY.DAT;1

File organization: Indexed, Prolog: 3, Using 4 keys
In 3 areas
Shelved state: Online
File attributes: Allocation: 270, Extend: 30, Maximum bucket size: 6, Global buffer count: 0, No version limit
Contiguous best try
Record format: Variable length, maximum 343 bytes, longest 0 bytes
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RE, World:
Access Cntrl List: None

UCX$ROUTE.DAT;1

File organization: Indexed, Prolog: 3, Using 2 keys
In 3 areas
Shelved state: Online
File attributes: Allocation: 99, Extend: 12, Maximum bucket size: 6, Global buffer count: 0, No version limit
Contiguous best try
Record format: Variable length, maximum 579 bytes, longest 0 bytes
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RE, World:RE
Access Cntrl List: None

UCX$SERVICE.DAT;1

File organization: Indexed, Prolog: 3, Using 4 keys
In 3 areas
Shelved state: Online
File attributes: Allocation: 90, Extend: 7, Maximum bucket size: 7, Global buffer count: 0, No version limit, Contiguous best try
Record format: Variable length, maximum 3072 bytes, longest 0 bytes
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RE, World:RE
Access Cntrl List: None


Do let me know if you want any more details.

Cheers,
Himanshu

[Willem Grooters]

What I need is the strcutures of the records themselves: how to read the data records themselves. I need this data to restore a UCX envrionment that suffered data inconsistency and therefore failed to start. Now it's up but minimal and the previous setting needs to be restored, without another interruption if that can be avoided.

Willem

[Kris Clippeleyr]

Willem,

Since all the UCX*.DAT files are indexed, you might want to try the ANALYZE/RMS/FDL & CONVERT/FDL combo; and a little reverse engineering.

I just used ANALYZE/RMS/FDL on UCX$HOST.DAT, & that revealed that it has 2 keys (one 15 bytes long starting at position 1, the other 255 long starting at postion 16), record format variable, record size 271.

Success,

Kris (aka Qkcl)

[Willem Grooters]

Kris,

The idea is good, gives you the key data but that is just half the story. I already looked in UCX$SERVICES.DAT, I can find out what port, user, command- and logfiles I need to set up but that requires handwork I'd like to prevent. And there can be more info in there that might be needed.

Willem

[Uwe Zessin]

I would 'bite the bullet' and recover it using normal setup interfaces (DCL menu and/or UCX command). Trying to mess with undocumented data structures in a critical environment does not sound like a good idea to me.