DB2 table names
Member IRRADULD in SYS1.SAMPLIB creates DB2® tables for each record type. Table 1 provides a useful reference of record type, record name, and DB2 table name.
| DB2 Table Name | Column Prefix | Description |
|---|---|---|
| JOBINIT | INIT | Job initiation |
| ACCESS | ACC | Resource access, other than file or directory |
| ADDVOL | ADV | ADDVOL/CHGVOL |
| RENAMEDS | REN | Rename data set |
| DELRES | DELR | Delete resource |
| DELVOL | DELV | Delete volume |
| DEFINE | DEF | Define resource |
| ADDSD | AD | ADDSD command |
| ADDGROUP | AG | ADDGROUP command |
| ADDUSER | AU | ADDUSER command |
| ALTDSD | ALD | ALTDSD command |
| ALTGROUP | ALG | ALTGROUP command |
| ALTUSER | ALU | ALTUSER command |
| CONNECT | CON | CONNECT command |
| DELDSD | DELD | DELDSD command |
| DELGROUP | DELG | DELGROUP command |
| DELUSER | DELU | DELUSER command |
| PASSWORD | PWD | PASSWORD command |
| PERMIT | PERM | PERMIT command |
| RALTER | RALT | RALTER command |
| RDEFINE | RDEF | RDEFINE command |
| RDELETE | RDEL | RDELETE command |
| REMOVE | REM | REMOVE command |
| SETROPTS | SETR | SETROPTS command |
| RVARY | RVAR | RVARY command |
| APPCLU | APPC | APPC session |
| GENERAL | GEN | General purpose |
| DIRSRCH | DSCH | Directory search |
| DACCESS | DACC | Check access to a directory |
| FACCESS | FACC | Check access to file |
| CHAUDIT | CAUD | Change audit options |
| CHDIR | CDIR | Change current directory |
| CHMOD | CMOD | Change file mode |
| CHOWN | COWN | Change file ownership |
| CLRSETID | CSID | Clear SETID bits for a file |
| EXESETID | ESID | EXEC with SETUID/SETGID |
| GETPSENT | GPST | Get z/OS UNIX process entry |
| INITOEDP | IOEP | Initialize z/OS UNIX process |
| TERMOEDP | TOEP | z/OS UNIX process complete |
| KILL | KILL | Terminate a process |
| LINK | LINK | LINK |
| MKDIR | MDIR | Make directory |
| MKNOD | MNOD | Make node |
| MNTFSYS | MFS | Mount a file system |
| OPENFILE | OPEN | Open a new file |
| PTRACE | PTRC | PTRACE authority checking |
| RENAMEF | RENF | Rename file |
| RMDIR | RDIR | Remove directory |
| SETEGID | SEGI | Set effective GID |
| SETEUID | SEUI | Set effective UID |
| SETGID | SGI | Set GID |
| SETUID | SUI | Set UID |
| SYMLINK | SYML | SYMLINK |
| UNLINK | UNL | UNLINK |
| UMNTFSYS | UFS | Unmount file system |
| CHKFOWN | CFOW | Check file owner |
| CHKPRIV | CPRV | Check z/OS UNIX privilege |
| OPENSTTY | OSTY | Open slave TTY |
| RACLINK | RACL | RACLINK command |
| IPCCHK | ICHK | Check IPC access |
| IPCGET | IGET | Make ISP |
| IPCCTL | ICTL | R_IPC control |
| SETGROUP | SETG | Set group |
| CKOWN2 | CKO2 | Check owner two files |
| ACCR | ACCR | Access rights passed |
| RACDCERT | RACD | RACDCERT command |
| RACFINIT | RINI | RACF® initialization data |
| CLASNAME | RINC | RACF class data |
| DSNSAFF | DSAF | Data sets affected by a security label change |
| INITACEE | INTA | initACEE functions |
| KTICKET | KTKT | Kerberos ticket |
| PDACCESS | PDAC | Policy Director Access Control Decision |
| PKIDPUBR | PKDP | CRL Publication |
| RPKIGENC | RPKG | R_PKIServ GENCERT |
| RPKIEXPT | RPKE | R_PKIServ EXPORT |
| RPKIREAD | RPKR | R_PKIServ Read Data |
| RPKISCEP | RPKS | R_PKIServ SCEP Request |
| RPKIUPDR | RPKU | R_PKIServ Update Request |
| RPKIUPDC | RPKC | R_PKIServ Update Certificate |
| SETFACL | SACL | R_Setfacl SETFACL |
| DELFACL | DACL | R_Setfacl DELFACL |
| SETFSECL | SSCL | R_setfsecl Set file security label |
| WRITEDWN | WDWN | R_writepriv Set writedown privilege |
| RPKIRESP | RPKO | R_PKIServ Respond |
| PTCREATE | PTCR | PassTicket Creation |
| PTEVAL | PTEV | PassTicket Evaluation |
| RDATAUPD | RPUT | R_Datalib |
| PKIAURNW | PKRN | PKI AutoRenew |
| PGMVERYF | PGMV | R_PgmSignVer |
| RACMAP | RACM | RACMAP command |
| AUTOPROF | AUTO | getUMAP/getGMAP automatic profile update |
| RPKIQREC | RPKQ | R_PKIServe QRECOVER |