on 05-15-2015 1:01 PM
Hi All,
I am in a situation which is weird and generates no logs.
This is a R/3 4.0B db DB2 7 running on AIX system, on which when I run DB12, SAP and DB2 freezes.
There are no logs and the OS freezes. Ultimately, we have to reboot the server.
The only thing that was observed was that db2sync process causing high paging.
I was not able to get time for a fix, so thought of sharing with you all and your expert comments before taking this further.
Regards,
Hello Divyanshu,
If you have access to OS level, check AIX errpt report, see if there is any issue with IO or any hard disk failures.
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dont think it will help .
If DB12 is the issue , and DB2 and OS ( aix ) freezes nothing is returned back to SAP . Keep facing this from 8 version .
The only command that DB2 ( AIX ) that helps to atleast debung from DB level is
db2fodc -hang [ Dont know whether the command is available in 7 )
all the best .. please update the progress
Thanks ,
Manu
Hello,
I just wanted to share a very useful command that will query DB2 for memory utilization even if DB2 does not respond using normal db2 CLI commands. With this command you can confirm any suspicion regarding DB2 memory issues.
Run this:
db2pd -dbptnmem
Regards,
NK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Divyanshu Srivastava wrote:
There are no logs and the OS freezes. Ultimately, we have to reboot the server.
The only thing that was observed was that db2sync process causing high paging.
Why you decided that OS freezes? What are you tried to do and couldn't that led you to the conclusion about OS hanging? Which tools have been used to see high paging for db2sync process? Which version of aix are you using?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure db2pd work on this version . If it does
Can you provide the following details
db2pd -version -osinfo
And after you run db12 please get an application snapshot
db2 "get snapshot for database manager"
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Divyan ,
Trouble for an expert
Can you confirm your DB2 Version ?
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.