z/OS FNA Revealed and Exposed

1
(No Transcript)
2
z/OS FNA Revealed and Exposed

• Phil Veal
• Senior Principal Support Engineer
• Bug Diagnosis and Escalations

3
Agenda
ltInsert Picture Heregt

• History
• File name transformation
• POSIX
• Syntax
• Examples

4
File Name Augmentation

• A brief history
• Available since MPM days (1980s)
• Pre-dates UNIX System Services and zFS/HFS
• Originally used Oracle C runtime library syntax
• Since Oracle 9.2.0, uses IBM LE syntax
• Backwards compatibility is maintained
• ORAENV ORA_RTL_COMPATON (default)

5
File Name Transformation

• Oracle utilities use simple file specifications
• E.g. myquery.sql, myquery.lst
• The native MVS file system uses datasets
• E.g. MYGROUP.LIB.SQL(MYQUERY), SPOOLOUT
• Question How to convert a file name to a
  dataset name automatically?
• Answer ORAFNA

6
POSIX(OFF) versus POSIX(ON)

• LE runtime parameter
• POSIX(ON)
• For UNIX System Services environment
• LE enclave uses POSIX semantics
• POSIX(OFF)
• Default for traditional MVS batch and TSO
  environments
• LE enclave uses non-POSIX semantics
• Simple file names are interpreted as datasets or
  files, as appropriate

7
File Name Syntax

• Old MPM syntax -
• /DD/name
• /DSN/name
• OSDI syntax -
• //DDname
• //name
• //SYSOUTclass
• Old syntax still accepted, but not recommended
• May be disabled via ORA_RTL_COMPAT (default ON)

8
FNA Syntax

• //ORAFNA DD DSNPATH
• FSA(
• FTYPE(extension)
• FNAME(new name)
• FATTR(attribute string)
• )

9
FTYPE

• File name type/extension
• Logical data type identifier
• Defaults defined by Oracle tools
• Usually 3 characters
• Examples
• .sql, .plb, .lst, .ctl, .log, .dmp
• Can be user defined

10
FNAME

• New transformed file name
• Original file specification may be included using
  
• Example 1 FNAME(MYLIB.SQL())
• stuff.sql -gt MYLIB.SQL(STUFF)
• Example 2 FNAME(MYGROUP.)
• stuff.sql -gt MYGROUP.STUFF.SQL
• PROFILE PREFIX (TSO) or USERID (batch) may be
  included using
• E.g. FNAME(//.LIB.SQL())

11
Examples
FSA( FTYPE(SQL) FNAME(LIB()) )
LIB.SQL(STUFF)
stuff.sql
FSA( FTYPE(SQL) FNAME(//DDSQL()) )
//DDSQL(STUFF)
stuff.sql
FSA( FTYPE(LST) FNAME('//SYSOUTX') )
//SYSOUTX
SPOOL report
12
FATTR

• File attribute assignment
• Output only
• Must begin with a semicolon
• Keywords
• RECFMV(B)F(B) etc.
• LRECLrecord length
• BLKSIZEblock size
• SPACE(units,(primary,secondary,directory
  blocks))
• Example -
• FATTR('space(trk,(2,1)),recfmVBA,lrecl137,blks
  ize0')

13
Questions?
14
ltInsert Picture Heregt
https//metalink.oracle.com/ Forums IBM z/OS
Platform
Phil.Veal_at_oracle.com