search cancel

What is error DSF=NAT when running DDTRSLM?

book

Article ID: 18224

calendar_today

Updated On:

Products

Compress Data Compression for MVS Compress Data Compression for Fujitsu Datacom DATACOM - AD Disk Backup and Restore - MVS DISK BACKUP AND RESTORE- ADD-ON OPTIO DISK BACKUP AND RESTORE Ideal CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

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: