Datacom Backup with or without UPDATE=YES
search cancel

Datacom Backup with or without UPDATE=YES

book

Article ID: 267109

calendar_today

Updated On:

Products

Datacom/AD Datacom/DB Datacom

Issue/Introduction

The sample syntax for  DATACOM backup SEQ=PHYSICAL specifies UPDATE=YES

BACKUP DBID=nnn,DDNAME=DATAOUT,RECID=YES,SEQ=PHYSICAL,UPDATE=YES               

We are now doing a native backup but the syntax does not specify UPDATE=YES, should it be added?

BACKUP DBID=nnn,DDNAME=DATAOUT,SEQ=NATIVE        

 

Environment

Release : 15.1

Resolution

The UPDATE=YES/NO keyword is only valid for a BACKUP SEQ=PHYSICAL.

For BACKUP SEQ=NATIVE the database cannot be updated while the backup is taking place so there's no need for an UPDATE= keyword. 

See the documentation section Back Up Data Area heading Native Sequence Backups: 

Native Sequence Backups

The native sequence backup uses the Native Key defined to each table in a data area to reorganize the data area in Native Key sequence.
You cannot use the native sequence for a backup if the Native Key is also defined as the direct access key.
A native sequence backup of a data area is not allowed if the database is open for update by any other task.
Once a Native Sequence backup begins, Datacom/DB does not allow an open for update.

And in the syntax section:

UPDATE=
Indicates whether the database can be open for update at the start or during the backup. When using MULTUSE=YES the area level controls apply when backing up an area.
Only valid if SEQ=PHYSICAL.