HP Integrity NonStop H-Series Guide de l'utilisateur télécharger pdf (Page 259)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

250

This optional parameter is used under the following conditions:

 In a HP NonStop to HP Shadowbase Other Servers environment,

PATHNAME contains the target filename for the open system.

PATHNAME accommodates filenames that are not typical HP NonStop

format.

 Version 4.092 introduced case-sensitive PATHNAMEs (i.e.,

“Table_Name”). In an Open to NonStop environment, PATHNAME

contains the source table name.

 When replicating dynamically created Enscribe files in NonStop to

NonStop replication environments.

o MAPFROMSOURCE DBS parameter must be used in

conjunction with PATHNAME in this scenario.

NonStop to Open replication considerations for using PATHNAME:

The DBS MAPFROMSOURCE parameter allows multiple source

files/tables within a particular NonStop subvolume and associated with a

single DBS object, to be individually identified (that is, separated) in the

SQL statements sent to the HP Shadowbase Other Servers.

The DBS PATHNAME parameter continues to be used to identify an HP

Shadowbase Other Servers target table for the SQL statements when

needed. This parameter has been enhanced such that a single ^ character

(circumflex) can be specified to have the source or target file name (right-

most 8 byte portion of the full file name) inserted into the PATHNAME

value when the SQL statement is generated. For example, if the source

file in the audit trail event contains \S1.$DATA1.MYSVOL.MYTAB01 and

you have a DBS PATHNAME set to OPEN-SERVER-^, the table name in

the SQL will contain OPEN-SERVER-MYTAB01.

The following are the rules used within the CONS to generate the table

name in the SQL statements sent to an Open Sever:

 If a user exit calls SBSETPATHNAME with a valid pathname, the

statement table name will be set to the UE pathname value (as is).

 Regardless of the MAPFROMSOURCE setting, if there is no

TARGETFILE and no PATHNAME and no user exit

SBSETPATHNAME, then the statement table name will be set to the

original event SOURCEFILE (8 byte portion read from the audit trail).

 If there is a TARGETFILE, but no PATHNAME and no user exit

SBSETPATHNAME, then the statement table name will be set to the

TARGETFILE (8 byte portion).

 If PATHNAME is set and does not have a ^ character in it, then the

statement table name will be set to the DBS PATHNAME value (as is).

1 2 ... 254 255 256 257 258 259 260 261 262 263 264 ... 345 346

Commentaires sur ces manuels

Pas de commentaire

HP Integrity NonStop H-Series Guide de l'utilisateur Page 259

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel HP Integrity NonStop H-Series