Updated ASE interview questions for User Mgmt n Permissions
Updated ASE interview questions for User Mgmt n Permissions
Today, I have registered new domain name for my fav blog as its title name http://sybaseblog.com.
Earlier wordpress domain will still work parallel.
So keep rocking sybase and happy learning n fun!!!!!
After the ASE 15.5 release and Sybase Q4 result, one more good news for all Sybase Guys…
4th Feb 2010, Sybase, Inc. (NYSE: SY), an industry leader in enterprise and mobile software, today announced that it has finalized an Asset Purchase Agreement with Aleri Inc. Aleri is a leading provider of enterprise-class complex event processing (CEP) technology and CEP-based solutions.
“With this transaction Sybase positions itself as a clear market leader in CEP. We have strengthened our real-time analytics platform, by adding Liquidity Risk Management and the industry leading Liquidity Management Suite,” said Dr. Raj Nathan, Senior Vice President and CMO of Sybase. “Our customers increasingly expect Sybase to provide a broad analytics portfolio to meet their growing needs and we are committed to continue to deliver on this vision.”
Keep Rocking sybase!!!
According to Forrester Research, “The Aleri platform is a strong product backed by a strong strategy.” Aleri is recognized as a standout leader in CEP in the Forrester Research, Inc., independent report published August 4, 2009 –”The Forrester Wave™: Complex Event Processing (CEP) Platforms,” Q3 2009. The full report can be found at http://www.forrester.com.
Aleri is focused on providing tools and solutions that deliver Continuous Intelligence ™ – allowing businesses to make better decisions through more timely insight and respond quickly to changing conditions. The centerpiece of this effort is Aleri’s Complex Event Processing (CEP) technologies, designed for high speed real-time analysis of data streams, with tools for rapid application development and deployment. Aleri offers a range of solutions to common business problems, with CEP at the core of all solutions. In March of 2008, Aleri merged with Coral8, another leading provider of CEP technology enabling the company to offer a complete suite of tools and solutions focused on continuous intelligence and business agility in a fast paced business environment. Founded in 1999 and headquartered in Chicago, Aleri was privately held at the time of the transaction.
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
IPC status from as of Thu Sep 17 08:50:11 EST 2007
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIME CTIME
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.
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
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..!
Source : Sybooks and UNIX Manuals on wwww.
Same Thread @ http://www.sybaseteam.com/cleaning-shared-memory-segment-semaphore-for-ase-startup-t-715.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!!
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.”
Sybase Software (India) Pvt. Ltd, the Indian subsidiary of Sybase, Inc., a provider of enterprise infrastructure and mobile software, today announced that it entered into a master reseller agreement with Inflow Technologies Pvt. Ltd in India.
The agreement will enable Inflow Technologies to extend the benefits of Sybase’s offerings, particularly analytics and enterprise mobility, to the growing market in India, said a press release.
Inflow Technologies, part of the US$ 5 billion Datatec Group, has presence in more than 12 locations across India and Sri Lanka.
Sources : news, www.
*Source : Sybase Resources on world wide web. Sybooks.
sysmessages and sysusermessages, which are read-only tables.
Auditing tables in sybsecurity, which are write-once and read many times.
Will post New Features part 2, once get completed.
If you find any new feature, which is very useful, please comment out in this section.
I came across the interesting issue on ASE Server.(Still not sure, need to check with sybase tech suport)
Suppose in our prod env, we have cross database referential integrity constraints, these referential integrity constraints stores in sysreferences table by relating the dbids of the two dbs(primary db and referenced db).
When we perform the refresh from one server to another (Suppose PROD – > UAT).These constraints come as it is in refreshed database. In refreshed dataserver, all dbs may not be created in same order as source dataserver, which results in dbid mismatch from source server.
Still our constraints are same as source db with source dbids.
When we run the dbcc checks on refreshed db, it starts flaging for the wrong dbid in sysreferences table.
Interesting ! Isn’t it?
In sybase manual and sybooks, I didn’t get any article related to db id mismatch, for cross db integrity constraints.
Will update u soon, if any.
In one case, I dropped out the syssrvroles accidently. Now, no one having any roles, even sa is not having its roles..I hav backup of all system tables and dump of master db. But We dont hav sso_role for any login we can’t do the bcp in , we can’t insert any row in any system table. Even we can’t change the allow update on system table, requires sso_role. Anyway. We have backup of master..so we can recover it..by loading the dump of master , but still need suggestions….