IBM Support

FMM9208E SQL2079N DB2 Snapshot fails with error 1

Troubleshooting


Problem

DB2 snapshot failing with FMM9208E System error 1: Operation not permitted. at position: esd-file.cpp(951).

Symptom

SQL2079N An error was reported by the shared library "libacsdb2.a". Return code: "30".

Cause

The /tmp directory does not have full permissions for the user.

Diagnosing The Problem

The return code 30 is from the DB2 api interface and indicates that a critical error has occurred.
Since the failure is reported on the shared library that makes the calls to the IBM Spectrum Protect Snapshot client, the the acsd, acsgend, client, and fcmclid traces should be investigated.

The client trace shows an error when attempting to remove a temporary file:
11:43:59.388 400 (1) esd-temporaryfile.cpp:54 Created tmp file '/tmp/fcm4u-qbb' for 3205.3631
11:43:59.388 400 (1) esd-temporaryfile.cpp:44 ... EXIT }
11:43:59.388 400 (1) esd-systemextended.cpp:449 { ENTRY ...
11:43:59.388 400 (1) esd-systemextended.cpp:449 ESD_SystemExtended::executeSysCommandFromAndToTempFileReturningFile
11:43:59.397 400 (1) esd-systemextended.cpp:449 ... EXIT }
11:43:59.397 400 (1) esd-file.cpp:461 { ENTRY ...
11:43:59.397 400 (1) esd-file.cpp:461 ESD_File::close() /tmp/fcm4u-qbb
11:43:59.397 400 (1) esd-file.cpp:461 ... EXIT }
11:43:59.397 400 (1) esd-temporaryfile.cpp:68 removeOnDelete=1

Resolving The Problem

The IBM Spectrum Protect Snapshot client uses the /tmp directory to create files that are utilized during the different stages of the processing. It is necessary for the /tmp directory to have full access permissions for the user that is performing the flashcopy so that these temporary files can be created/modified/deleted.

  • Ensure the user that is logged on and performing the snapshot has full access permissions to the /tmp directory.
  • Ensure that the acsgen daemon has been started (running) by the root user (on both hosts) so that full permissions are existing for the necessary processing.

[{"Product":{"code":"SSERFV","label":"IBM Spectrum Protect Snapshot"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"FlashCopy Manager for DB2","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"4.1.4;4.1.6","Edition":"Edition Independent","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM FCM

Document Information

Modified date:
01 February 2022

UID

swg22006780