IBM Support

SQL2062N using NetBackup

Troubleshooting


Problem

A SQL2062N error may be reported during a backup attempt if the host(s) do not match up between the NetBackup host and the DB2 hosts (db2nodes.cfg)

Symptom

The following errors and remarks will be noted in the db2diag.log

2009-04-10-11.47.19.606562-300 I25853080A940 LEVEL: Error
PID : 700474 TID : 10832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48102 APPID: *LOCAL.inrtdp.090410163605
AUTHID : DB2INST1
EDUID : 10832 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubDeleteVendorImage, probe:558
MESSAGE : SQL2062N An error occurred while accessing media "". Reason
code:
"".
DATA #1 : String, 27 bytes
Error returned by sqluvdel.
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000001A=26 -- see DB2 API Guide for meaning.
DATA #3 : Hexdump, 48 bytes
0x07000000383E1BB0 : 0000 01F9 4E65 7442 6163 6B75 7020 4442
....NetBackup DB
0x07000000383E1BC0 : 3220 496E 7075 7420 496E 7661 6C69 6400 2 Input
Invalid.
0x07000000383E1BD0 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2009-04-10-11.47.19.608042-300 E25854021A598 LEVEL: Error
PID : 700474 TID : 10832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48102 APPID: *LOCAL.inrtdp.090410163605
AUTHID : DB2INST1
EDUID : 10832 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup,
probe:708
MESSAGE : SQL2062N An error occurred while accessing media "". Reason
code:
"".
DATA #1 : String, 63 bytes
Could not delete partial backup image created on vendor device.

2009-04-10-11.47.19.631822-300 E25854620A427 LEVEL: Severe
PID : 700474 TID : 10832 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48102 APPID: *LOCAL.inrtdp.090410163605
AUTHID : DB2INST1
EDUID : 10832 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:848
MESSAGE : Backup terminated.

Cause

The hostname being used for NetBackup is not a valid name.

Diagnosing The Problem

The most common problem here is an incorrect hostname being used by NetBackup. Compare the hostname in both the db2nodes.cfg with Netbackup hostname

Resolving The Problem

Correct the hostname being used by Netbackup ensuring it matches the hostname being used by DB2 in the db2nodes.cfg

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 December 2022

UID

swg21382709

Page Feedback