Dale thanks for the very quick response.
The db2level is : DB21085I Instance "pdb2ardb" uses DB2 code release "SQL07025" with level identifier "03060105" and informational tokens "DB2 v7.1.0.68", "s020616" and "U484480". Hope this helps. The list tablespaces gave no tablespace in a NON 0 state. Can you tell me what the state 800 and state 400 mean? best regards Leslie -----Original Message----- From: Dale McInnis [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 1:35 PM To: Pendlebury-Bowe, Leslie Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [DB2EUG] Error on Backup SQL0969N? Leslie The ffff 8138 in an internal return code indicating that one of your tablespaces is in a state that is incompatible with backup. I would proceed by checking the state of all of my tablespaces using the "db2 list tablespaces" command. Can you please send me the output from the "db2level" command so that I can ensure this internal error code is properly mapped to a external error code. Regards, _____________________________________________ Dale M. McInnis IBM Toronto Lab Senior Technical Manager, DB2 / LUW Backup, Data Protection and Recovery Email: [EMAIL PROTECTED] Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397 "Pendlebury-Bowe, Leslie" <Leslie.Pendlebur To [EMAIL PROTECTED] [EMAIL PROTECTED] m> cc Sent by: [EMAIL PROTECTED] Subject ash.org [DB2EUG] Error on Backup SQL0969N? 09/29/2003 06:57 AM Please respond to "Pendlebury-Bowe, Leslie" <Leslie.Pendlebur [EMAIL PROTECTED] m> Hi all Has anybody had the following before when backing up to ADSM? Database Connection Information Database server = DB2/6000 7.2.5 SQL authorization ID = PDB2ARDB Local database alias = RID SQL0969N There is no message text corresponding to SQL error "-32456" in the message file on this workstation. The error was returned from module "buildApp" with original tokens "". I have just performed an online backup to TSM (ADSM) and all seems ok now. What a mystery ... >From DB2diag we get : Starting a full database backup. 2003-09-28-11.04.41.892309 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 buffer_pool_services sqlbCheckStateTransition Probe:0 Database:RID DIA9999E An internal error occurred. Report the following error code : "0xFFFF8138". 2003-09-28-11.04.41.930860 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 buffer_pool_services sqlbTestSetDatapoolState Probe:633 Database:RID DIA9999E An internal error occurred. Report the following error code : "0xFFFF8138". 2003-09-28-11.04.41.934480 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 buffer_pool_services sqlbTestSetDatapoolState Probe:633 Database:RID oldState = 0, newState = 800, currentState = 400 2003-09-28-11.04.41.941418 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 buffer_pool_services sqlbTestSetDatapoolState Probe:778 Database:RID DIA9999E An internal error occurred. Report the following error code : "0xFFFF8138". 2003-09-28-11.04.41.943789 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 database_utilities buildAppTblsp Probe:22 Database:RID DiagData ffff 8138 yy.8 2003-09-28-11.04.41.955680 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 database_utilities buildAppTblsp Probe:22 Database:RID DiagData ffff 8138 yy.8 2003-09-28-11.04.41.966026 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 database_utilities buildAppTblsp Probe:22 Database:RID ffff 8138 yy.8 2003-09-28-11.04.42.745318 Instance:pdb2ardb Node:000 PID:50220(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030928100440 database_utilities sqlubcka Probe:0 Database:RID Backup terminated. 2003-09-29-10.27.10.937693 Instance:pdb2ardb Node:000 PID:41914(db2agent (RID)) Appid:*LOCAL.pdb2ardb.030929092710 database_utilities sqlubcka Probe:0 Database:RID Best regards Leslie **************************************************************************** ******************* The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. This email and any response may be monitored by Sony United Kingdom Limited. (gfd) **************************************************************************** ******************* **************************************************************************** ******************* The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. This email and any response may be monitored by Sony United Kingdom Limited. (04) **************************************************************************** ******************* - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc ********************************************************************************************** The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. This email and any response may be monitored by Sony United Kingdom Limited. (05) ********************************************************************************************** - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
