Scribd
Upload
349 views3 pages

Cartridge Checkin Problem

The document describes errors encountered during an attempt to insert a row for volume BML115L7 into the MMS_LIB_INVENTORY table. This violated the check constraint MMSLBI_11. It also provides diagnostic information about the library PRIMARYLIB, drive DRIVE1, and tape configuration including the 3580 tape drive and 3573 medium changer.

Uploaded by

Md Abdullah Al Mamun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
349 views3 pages

Cartridge Checkin Problem

The document describes errors encountered during an attempt to insert a row for volume BML115L7 into the MMS_LIB_INVENTORY table. This violated the check constraint MMSLBI_11. It also provides diagnostic information about the library PRIMARYLIB, drive DRIVE1, and tape configuration including the 3580 tape drive and 3573 medium changer.

Uploaded by

Md Abdullah Al Mamun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

ANR0162W Supplemental database diagnostic information: -1:23513:-545 ([IBM][CLI

Driver][DB2/AIX64] SQL0545N The requested operation is not allowed because a row


does
not satisfy the check constraint "TSMDB1.MMS_LIB_INVENTORY.MMSLBI_11".
SQLSTATE=23513
).
ANR0157W Database operation INSERT for table MMS.Lib.Inventory failed with result
code 2332 and tracking ID: 111fd5208.
ANR0158W Database operation INSERT for table MMS.Lib.Inventory failed with
operation code 2332 and tracking id 111fd5208. The data for column 0 is: (string,
len=10)0x5052494D4152594C4942.
ANR0158W Database operation INSERT for table MMS.Lib.Inventory failed with
operation code 2332 and tracking id 111fd5208. The data for column 1 is: (string,
len=8)0x424D4C3131354C37.
ANR9999D_2545085644 MmsCreateInvEntry(mmslib.c:9550) Thread<111>: Unable to insert
inventory row for volume BML115L7 in library PRIMARYLIB; rc=2332.
ANR9999D Thread<111> issued message 9999 from:
ANR9999D Thread<111> 0x000000010001cc50 StdPutText
ANR9999D Thread<111> 0x000000010001d6b0 OutDiagToCons
ANR9999D Thread<111> 0x00000001000098c8 outDiagfExt
ANR9999D Thread<111> 0x00000001003f17ec MmsCreateInvEntry
ANR9999D Thread<111> 0x0000000100a15a08 CheckInVolume
ANR9999D Thread<111> 0x00000001009fb324 EECheckinVolume
ANR9999D Thread<111> 0x00000001009f9910 ScsiCheckinVolume
ANR9999D Thread<111> 0x0000000100563588 MmsLtsCheckinVolume@AF83_44
ANR9999D Thread<111> 0x00000001003fa584 CheckinThread
ANR9999D Thread<111> 0x000000010000cb40 StartThread
ANR8841I Remove volume from slot 16 of library PRIMARYLIB at your convenience.
ANR8832E CHECKIN LIBVOLUME for volumes in search mode in library PRIMARYLIB failed.
ANR0985I Process 2 for CHECKIN LIBVOLUME running in the BACKGROUND completed with
completion state FAILURE at 14:59:24.
ANR1893E Process 2 for CHECKIN LIBVOLUME completed with a completion state of
FAILURE.
===========================================================
tsm: BMLTSM>q library f=d

Library Name: PRIMARYLIB


Library Type: SCSI
ACS Id:
Private Category:
Scratch Category:
WORM Scratch Category:
External Manager:
Shared: Yes
LanFree:
ObeyMountRetention:
Primary Library Manager:
WWN: 2001000E11163898
Serial Number: 00L2U78BY372_LL0
AutoLabel: Yes
Reset Drives: Yes
Relabel Scratch: No
ZosMedia:
Last Update by (administrator): ADMIN
Last Update Date/Time: 12/12/17 12:50:52

tsm: BMLTSM>q drive f=d


Library Name: PRIMARYLIB
Drive Name: DRIVE1
Device Type: LTO
On-Line: Yes
Read Formats:
ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5,ULTRIUM4C,ULTRIUM4
Write Formats: ULTRIUM6C,ULTRIUM6,ULTRIUM5C,ULTRIUM5
Element: 256
Drive State: EMPTY
Volume Name:
Allocated to:
WWN: 2001000E11163898
Serial Number: 1068012598
Last Update by (administrator): ADMIN
Last Update Date/Time: 12/12/17 12:51:18
Cleaning Frequency (Gigabytes/ASNEEDED/NONE): ASNEEDED

tsm: BMLTSM>
================================
tsm: BMLTSM>q no

Node Name Platform Policy Domain Days Since Days


Since Locked?
Name Last Acce-
Password
ss
Set
------------------------- -------- -------------- ----------
---------- -------
BMLECCDEV LinuxPP- LANFREE_DOMAIN <1
<1 No
C64
BMLECCPRD LinuxPP- LANFREE_DOMAIN <1
<1 No
C64
BMLGWTDEV AIX LANFREE_DOMAIN <1
110 No
BMLTSM AIX LANFREE_DOMAIN 43
110 No

========================================
bash-4.3# lsdev -Cc tape
rmt0 Available 02-01-01 IBM 3580 Ultrium Tape Drive (FCP)
smc0 Available 02-01-01 IBM 3573 Tape Medium Changer (FCP)
bash-4.3# lscfg -vpl rmt0
rmt0 U78C9.001.WZS0YV2-P1-C2-T2-W2002000E11163898-L0 IBM 3580
Ultrium Tape Drive (FCP)

Manufacturer................IBM
Machine Type and Model......ULT3580-HH6
Serial Number...............1068012598
Device Specific.(FW)........G9P1

PLATFORM SPECIFIC

Name: tape
Node: tape
Device Type: byte
bash-4.3# lscfg -vpl smc0
smc0 U78C9.001.WZS0YV2-P1-C2-T2-W2002000E11163898-L1000000000000 IBM
3573 Tape Medium Changer (FCP)

Manufacturer................IBM
Machine Type and Model......3573-TL
Serial Number...............00L2U78BY372_LL0
Device Specific.(FW)........E.20

PLATFORM SPECIFIC

Name: tape
Node: tape
Device Type: byte
========================================================
bash-4.3# lslpp -l | grep Atape
Atape.driver 13.0.22.0 COMMITTED IBM AIX Enhanced Tape and
bash-4.3#
=============================

You might also like