What is error DSF=NAT when running DDTRSLM?

book

Article ID: 18224

calendar_today

Updated On:

Products

CA Compress Data Compression for MVS CA Compress Data Compression for Fujitsu CA Datacom CA DATACOM - AD CA Disk Backup and Restore - MVS CA DISK BACKUP AND RESTORE- ADD-ON OPTIO CA DISK BACKUP AND RESTORE CA Ideal CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware CA Datacom/AD

Issue/Introduction

Description:

Running DDTRSLM to IMPORT an SQL Table definition fails with

DDTRS0015E ADDOCC FAILED DSF COMMAND STRADD, RC: NAT.

Solution:

During the DDTRSLM IMPORT TABLE a Table entity-occurrence insertion in DATA-DICT fails with DSF error NAT .
DSF RC=NAT means NO SUCH AUTHID .
Each table that is SQL-able has an AUTHID (Schema Authorization-id) .
In the Datadictionary environment where this IMPORT TABLE runs this AUTHID that this table uses does not exist .

An AUTHID can be added by running DBSQLPR CREATE SCHEMA AUTHORIZATION name;
or by running DDUPDATE
-USR …
-BTG AUTHORIZATION,name
1500 AUTH-USAGE,S
-END
-UPD AUTHORIZATION,name(0001),PROD
-END

Environment

Release: DATABB00200-14-Datacom/AD
Component: