Db2 Error 912
SQL0912N IF LOCKLIST CONFIGURATION IS VERY LOW z/os Fixes are available DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description A database migration to DB2 Version 9.7 may fail with error SQL0912N. This can happen if the locklist database configuration parameter is set to a very low value, for example (LOCKLIST) = AUTOMATIC(25) pages. A typical error that is seen during implicit migration: db2 "RESTORE DATABASE MYDB FROM 'C:\Program Files\IBM\temp' ON C: INTO NEWDB" SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-912" with tokens "*N" is returned. and in db2diag.log you should find messages like this: 2011-05-25-15.51.32.381000+120 I1201435F313 LEVEL: Warning PID : 644 TID : 4576 PROC : db2bp.exe INSTANCE: DB2 NODE : 000 APPID : *LOCAL.DB2.110525134946 EDUID : 4576 FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:30 MESSAGE : Begin db2spcat 2011-05-25-15.51.40.256000+120 I1201750F815 LEVEL: Severe PID : 1028 TID : 1288 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : OO APPHDL : 0-86 APPID: *LOCAL.DB2.110525134946 AUTHID : ADMINISTRATOR EDUID : 1288 EDUNAME: db2agent (OO ) 0 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0 MESSAGE : SYS_VIEWS: sqlcode DATA #1 : Hexdump, 57 bytes 0x00000000303D3DB0 : 4372 6561 7465 2053 5953 5445 4D20 5649 Create SYSTEM VI 0x00000000303D3DC0 : 4557 2053 5953 4341 542E 574F 524B 4143 EW SYSCAT.WORKAC 0x00000000303D3DD0 : 5449 4F4E 5320 6661 696C 6564 2077 6974 TIONS failed wit 0x00000000303D3DE0 : 6820 7263 3D2D 3931 32 h rc=-912 A typical error symptom of that probl
argument; vob_db; vobrpc; db_server; 1123349; error seeking in database file; errno == "Invalid argument"; errno ==; Invalid argument Technote (troubleshooting) Problem(Abstract) This technote explains why the IBM Rational ClearCase logs identify database error, db_VISTA database error -912, and provides instructions to troubleshoot the problem. Symptom The following errors may be seen in the vobrpc_server_log: 04/26/00 11:20:20 vobrpc_server(16502): Ok: Rollforward http://www.ibm.com/support/docview.wss?uid=swg1IC77415 recovery using "/usr/vobstore/myvob.vbs/db/vista.tjf" started Wed Apr 26 11:20:20 2000 04/26/00 11:20:20 vobrpc_server(16502): Ok: 04/26/00 11:20:20 vobrpc_server(16502): Ok: *** db_VISTA database error -912 - error seeking in database file 04/26/00 11:20:20 vobrpc_server(16502): Ok: Rollforward recovery using "/usr/vobstore/myvob.vbs/db/vista.tjf" failed Wed Apr 26 11:20:20 2000 04/26/00 11:20:20 vobrpc_server(16502): Ok: : status -912 http://www.ibm.com/support/docview.wss?uid=swg21123349 04/26/00 11:20:20 vobrpc_server(16502): Error: DBMS error in /usr/vobstore/myvob.vbs/db. 04/26/00 11:20:20 vobrpc_server(16502): Error: db_VISTA error -912 (errno == "Invalid argument") 04/26/00 11:20:20 vobrpc_server(16502): Error: Cannot open database in "/usr/vobstore/myvob.vbs/db" 04/26/00 11:20:20 vobrpc_server(16502): Error: Error from VOB database: "/vobs/myvob". 04/26/00 11:20:20 vobrpc_server(16502): Error: Trouble opening VOB database: "/vobs/myvob". The db_server_log also contains the following errors: 04/26/00 11:20:20 db_server(16383): Ok: Rollforward recovery using "/usr/vobstore/myvob.vbs/db/vista.tjf" started Wed Apr 26 11:20:20 2000 04/26/00 11:20:20 db_server(16383): Ok: 04/26/00 11:20:20 db_server(16383): Ok: *** db_VISTA database error -912 - error seeking in database file The view_log also contains the following errors: 04/26/00 11:20:20 view_server(16314): Error: Unexpected error in VOB "myhost:/usr/vobstore/myvob.vbs" op vob_ob_get_gen_num:error detected by ClearCase subsystem See vobrpc_server_log on host myhost 04/26/00 11:20:20 view_server(16314): Warning: Unable to open vob 'myhost:/usr/vobstore/myvob.vbs': unknown error in VOB Cause This error can relate to one or more of the following problems: Disk Space Confused Processes Database Limita
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development & Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base Spotlight on DB2 Error during connection: "SQL1476N The current transaction was rolled back because of error -973. SQLSTATE=40506" (43534) × Ret