Panic dataserver, stopping it manually, and on restart showing issues with memory , meanwhile business people wants updates in every 5 mins...The situation is really worst for a DBA.
This posting is related to shared memory problem, for cleaning the shared memory:
When we shutdown the Sybase dataserver abruptly, by using the kill -9 or kill -12(or due to any reason automatically).
During the restart, sometime it gives the problem unable to create shared memory region, as below:
os_create_region: shmget (0x%x): %s
os_create_region: Shared memory segment %d is in the way
os_create_region: uninitialized shared memory descriptor
os_create_region: shmat (%d): %
Killing Process may left behind the System V semaphore or shared memory left behind instead of being cleaned up automatically. To eliminate unneeded semaphores or shared memory segments, we need to release semaphore or shared memory segment manually.
For the Semaphores:
Run the command ipcs -sa, it will give all semaphores active in the UNIX box, look for the value "0" in the column NSEMS. 0 values indicate that unused semaphore, find all semaphore for the Sybase user and remove them using command ipcrm -s
testinghostname:(/sybase)=>ipcs -sa
IPC status from as of Thu Sep 17 08:50:11 EST 2007
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
Semaphores:
s 201326671 0xc103d804 --ra-ra-ra- patrol dba patrol dba 2 8:45:15 0:00:08
s 201326668 0xc103d80e --ra-ra-ra- sybase dba sybase dba 0 8:50:08 0:00:00
testinghostname:(/sybase)=>ipcrm -s 201326668
For the Shared Memory:
To cleanup the Shared memory segment, which are assigned at OS level but not in use, run ipcs -ma command.
testinghostname:(/sybase)=>ipcs -ma
IPC status from as of Thu Sep 17 08:50:24 EST 2007
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
Shared Memory:
m 654311446 0x4103d80e --rw-rw-rw- patrol dba patrol dba 0 2304 1766 1766 8:50:18 8:50:18 0:00:08
m 671088657 0x4103d80d --rw-rw-rw- sybase dba sybase dba 0 1792 1766 1762 8:45:15 8:45:15 0:00:08
m 671088650 0x4103d80b --rw-rw-rw- root root root root 0 768 1766 1766 8:50:18 8:50:18 0:00:08
m 671088648 0x4103d80a --rw-rw-rw- sybase dba sybase dba 1 1280 1766 1766 8:50:18 8:50:18 0:00:08
m 654311548 0x4103d809 --rw-rw-rw- sybase dba sybase dba 0 256 1766 1766 8:50:08 8:50:08 0:00:08
Now look in the NATTCH field for 0, if it 0 zero for Sybase user , it is unneeded, but still assigned at OS level. Remove it ipcrm -m by providing the id.
testinghostname:(/sybase)=>ipcrm -m 671088657 -m 654311548
Now Start the dataserver....
Same case with backup server, if u get any error with shared memory..!
Thanks.
Source : Sybooks and UNIX Manuals on wwww.
Same Thread @ http://www.sybaseteam.com/cleaning-shared-memory-segment-semaphore-for-ase-startup-t-715.html
Saturday, January 30, 2010
Thursday, January 28, 2010
Sybase Delivers Best Quarter in Company History in 25 yrs!!!
All,
Very Good News for Sybase Folks!!!!
Sybase, Inc. Sybase reported record results for the quarter and full year ended Dec. 31, 2009. Among the company's records were Q4 revenue of $331.7 million, annual revenue of $1.17 billion, and record operating margins and cash flow from operations. The company's strong Q4 performance completes the best year in Sybase’s 25-year history.
Sybase Delivers Best Quarter in Company History, Resulting in Third Consecutive Year of Record Revenue!!
Cheers!!!
Source : http://www.sybase.com/detail?id=1067077
Same thread @ http://www.sybaseteam.com/sybase-strong-q42009-performance-completes-best-year-its-t-714.html
Very Good News for Sybase Folks!!!!
Sybase, Inc. Sybase reported record results for the quarter and full year ended Dec. 31, 2009. Among the company's records were Q4 revenue of $331.7 million, annual revenue of $1.17 billion, and record operating margins and cash flow from operations. The company's strong Q4 performance completes the best year in Sybase’s 25-year history.
Sybase Delivers Best Quarter in Company History, Resulting in Third Consecutive Year of Record Revenue!!
Cheers!!!
Source : http://www.sybase.com/detail?id=1067077
Same thread @ http://www.sybaseteam.com/sybase-strong-q42009-performance-completes-best-year-its-t-714.html
Sybase ASE 15.5 Meets Extreme Performance, Efficiency & Service Level Demands of Next-Generation Transaction Processing Systems
Source : www & http://www.sybase.com/detail?id=1067065.
:)
New Version Includes In-Memory Database Option to Enable Data Virtualization in Cloud and Grid Environments
Sybase, Inc. (NYSE: SY), an industry leader in enterprise and mobile software, today announced the availability of Sybase® Adaptive Server® Enterprise (ASE) 15.5, the newest version of its high-performance, mission-critical enterprise database management system.
Sybase ASE 15.5 features the addition of two new options: ASE In-memory Databases (IMDB) and Advanced Backup Services. With these enhancements, ASE 15.5 continues to deliver unparalleled performance and manageability for data intensive environments that require very low response times and high throughput.
The IMDB option in Sybase ASE 15.5 enables data virtualization and scaling critical to meeting the needs of high data volume and high concurrent user organizations, whether deployed in public cloud or private data center environments. Unlike other in-memory products, the ASE 15.5 IMDB is fully integrated within ASE, eliminating the need for application changes and providing the flexibility that allows in-memory databases to be configured to meet application requirements.
“In-memory DBMS is an important dimension of the DBMS landscape, and will become more so in the coming years,” said Carl Olofson, Vice President of Research at IDC. “The Sybase developments that provide transparent in-memory database management show clear leadership in the DBMS field.”
ASE 15.5 also increases efficiency in the data center with the integration of the ASE Backup Server with Tivoli® Storage Manager (TSM) from IBM. With this support, ASE databases can be backed up on any TSM supported media, providing faster backups and restores with less network and storage resources required. This new integration provides a cost effective solution for storage management.
“The database management features offered by Sybase ASE 15.5 coupled with the storage management features offered by IBM® TSM provide a powerful solution to overcome the challenges of data protection faced in today’s business environment.” said Richard Vining, Product Marketing Manager, IBM Tivoli Storage. “We are pleased to provide Sybase ASE with the Ready for Tivoli software designation, which shows customers that the solution meets or exceeds IBM compatibility criteria and successfully integrates with one or more IBM Tivoli Software products.”
"In data centers, the IT challenge is to increase efficiency and availability while lowering data center costs. At the same time, application deployments in grid and cloud computing environments are increasing the requirements of transaction processing systems to support large volumes of concurrent users with high transaction rates,” said Brian Vink, vice-president, data management products, Sybase. “ASE 15.5 addresses these extreme requirements by delivering increased data throughput and greater concurrent activity while elevating productivity and uptime.”
:)
New Version Includes In-Memory Database Option to Enable Data Virtualization in Cloud and Grid Environments
Sybase, Inc. (NYSE: SY), an industry leader in enterprise and mobile software, today announced the availability of Sybase® Adaptive Server® Enterprise (ASE) 15.5, the newest version of its high-performance, mission-critical enterprise database management system.
Sybase ASE 15.5 features the addition of two new options: ASE In-memory Databases (IMDB) and Advanced Backup Services. With these enhancements, ASE 15.5 continues to deliver unparalleled performance and manageability for data intensive environments that require very low response times and high throughput.
The IMDB option in Sybase ASE 15.5 enables data virtualization and scaling critical to meeting the needs of high data volume and high concurrent user organizations, whether deployed in public cloud or private data center environments. Unlike other in-memory products, the ASE 15.5 IMDB is fully integrated within ASE, eliminating the need for application changes and providing the flexibility that allows in-memory databases to be configured to meet application requirements.
“In-memory DBMS is an important dimension of the DBMS landscape, and will become more so in the coming years,” said Carl Olofson, Vice President of Research at IDC. “The Sybase developments that provide transparent in-memory database management show clear leadership in the DBMS field.”
ASE 15.5 also increases efficiency in the data center with the integration of the ASE Backup Server with Tivoli® Storage Manager (TSM) from IBM. With this support, ASE databases can be backed up on any TSM supported media, providing faster backups and restores with less network and storage resources required. This new integration provides a cost effective solution for storage management.
“The database management features offered by Sybase ASE 15.5 coupled with the storage management features offered by IBM® TSM provide a powerful solution to overcome the challenges of data protection faced in today’s business environment.” said Richard Vining, Product Marketing Manager, IBM Tivoli Storage. “We are pleased to provide Sybase ASE with the Ready for Tivoli software designation, which shows customers that the solution meets or exceeds IBM compatibility criteria and successfully integrates with one or more IBM Tivoli Software products.”
"In data centers, the IT challenge is to increase efficiency and availability while lowering data center costs. At the same time, application deployments in grid and cloud computing environments are increasing the requirements of transaction processing systems to support large volumes of concurrent users with high transaction rates,” said Brian Vink, vice-president, data management products, Sybase. “ASE 15.5 addresses these extreme requirements by delivering increased data throughput and greater concurrent activity while elevating productivity and uptime.”
Subscribe to:
Posts (Atom)