on 09-03-2009 9:36 AM
Hello Experts,
I have successfully installed a ECC 6.0 System-ABAP + JAVA (DB2 v9.5 windows server 2008-x64 bit).
Kernel: 700 , Patch: 185 ; SP level : rel 700 , level 17.
However now i suddenly cannot connect to database and SAP is down.
C:\Users\dsqadm.DUCATI>r3trans -d
This is r3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = DB6 --- DB2DB
DFT = 'DSQ'"
r3trans finished (0012).
db2diag.log:-
______________________________________________________________________________________________________
ADM1823E The active log is full and is held by application handle "51886". Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.
"Log File has reached its saturation point" DIA8309C Log file was full.
"Backup pending. Database has been made recoverable. Backup now required." DIA8168C Backup pending for database .
_______________________________________________________________________________________________________
Also, regarding DB2 licensing,i have a query:
db2licm -l gives the following:
______________________________________________________________________________-
C:\Users\db2dsq.DUCATI>db2licm -l
Product name: "DB2 Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.5"
Enforcement policy: "Soft Stop"
Features:
DB2 Database Partitioning: "Licensed"
DB2 Performance Optimization ESE: "Licensed"
DB2 Storage Optimization: "Licensed"
DB2 Advanced Access Control: "Not licensed"
DB2 Geodetic Data Management: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
Product name: "DB2 Connect Server"
License type: "Trial"
Expiry date: "10/19/2009"
Product identifier: "db2consv"
Version information: "9.5"
_______________________________________________________________________________
I have applied both sap and DB2 license. Is everything ok regarding licensing of DB v9.5 for using with SAP?
I am new to DB2 database and looking for expert guidance regarding the above mentioned issues.
Thanks,
Rakesh
This is nice too:
SELECT DB_NAME AS "DB Name",
CASE (TOTAL_LOG_AVAILABLE)
WHEN -1 THEN DEC(-1,5,2)
ELSE DEC(100 * (FLOAT(TOTAL_LOG_USED)/FLOAT(TOTAL_LOG_USED + TOTAL_LOG_AVAILABLE)), 5,2) END AS "Log used %",
TOTAL_LOG_USED / 1024/1024 AS "Total log used/MB",
CASE (TOTAL_LOG_AVAILABLE)
WHEN -1 THEN -1
ELSE TOTAL_LOG_AVAILABLE / 1024/1024 END AS "Total log available/MB",
TOT_LOG_USED_TOP / 1024/ 1024 AS "Total log used TOP/MB",
APPL_ID_OLDEST_XACT AS "ID oldest transaction",
DBPARTITIONNUM
FROM SYSIBMADM.SNAPDB
Best regrads,
Joachim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rakesh,
first you should try to find out which application is holding the oldest transaction.
db2 get snapshot for applications on <DBNAME>
and look for application handle "51886".
This will show you, if its a Java or ABAP Stack related problem and may also give you more information based on the last executed SQL Statement and maybe the TPMON attributes in the snapshot.
To release the locks you can force the application from the database
db2 " force application ( 51886 ) "
But make sure that you capture the snapshot information first to get some hint about the root cause.
Regards
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rakesh,
are your monitoring switches turned on? SAP default settings are
> db2 get dbm cfg | grep MON
Transaction processor monitor name (TP_MON_NAME) =
Buffer pool (DFT_MON_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = ON
Monitor health of instance and databases (HEALTH_MON) = OFF
Regards
Frank
C:\Users\db2dsq.DUCATI>db2 get dbm cfg
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0c00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) = 4,723442e-007
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1,000000e+002
Max number of concurrently active databases (NUMDB) = 8
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = ON
Monitor health of instance and databases (HEALTH_MON) = OFF
Hello,
in your initial post I have seen that you have posted another error message from db2diag.log.
"Backup pending. Database has been made recoverable. Backup now required." DIA8168C Backup pending for database .
Does this occur after the log file full message?
Maybe you problem is not related to the log fill condition.
As db2<sid> user, what does a "db2 connect to <sid>" command return?
Edited by: Hans-Juergen Moldowan on Sep 3, 2009 12:37 PM
Hello,
most probably you recently have switched from DB2 circular logging to DB2 archival logging, e.g. by modifying the LOGARCHMETH1 DB CFG parameter.
After a DB2 restart this gets active and for security reasons DB2 ensures that an offline backup is taken.
That is exactly what is also mentioned in the SQL1116N - BACKUP PENDING.
You need to perform a full offline backup of your database.
Rakesh,
You can run a full DB2 backup if it is absolutely necessary. However if you feel that backup is not necessary (i.e. this is being copied to a sandbox for testing purpose) there is a backdoor method to get the database out of backup pending.
Issue the following as the instance owner (db2<sid>):
db2dart <SID> /chst /what dbbp off
This will change the state of the database to backup-pending off.
Regards,
Sameer
Hello,
please handle this with extreme care.
If you need to recover your database you only can perform a version restore to the state of your last backup before the db2dart command.
Therefore I recommend the backup option.
If you are using the db2dart, please make sure to perform a full offline backup asap.
More information on performing backups can be found here:
[A Practical Guide to Backup and Recovery of IBM DB2 for Linux, UNIX and Windows in SAP Environments Part 1: Backup and Recovery - Overview|https://www.sdn.sap.com/irj/sdn/db6?rid=/library/uuid/80e61772-e471-2c10-60b1-9529b69b50c5]
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.