HPE Community
Operating System - HP-UX
1840212 Members
3119 Online
110162 Solutions
New Discussion

Re: How to set up 2 GB of RAM for tempdb in Sybase

 
Kelvin Yu
Advisor

‎01-09-2004 08:57 AM

‎01-09-2004 08:57 AM

How to set up 2 GB of RAM for tempdb in Sybase

Hi,

We are running 11i and Sybase 12.0 and would like to find out that there is a way to configure 2GB of RAM as the tempdb. Any help or anywhere to find the documents appreciated. Thanks.

Best regards,
Kelvin
0 Kudos
Reply
2 REPLIES 2
Michael Schulte zur Sur
Honored Contributor

‎01-09-2004 10:09 AM

‎01-09-2004 10:09 AM

Re: How to set up 2 GB of RAM for tempdb in Sybase

Hi,

I am not sure, if I get you right. You should create with disk init a device file with 2gb and then extend it with alter database. Both commands you can see here:
http://sybooks.sybase.com/onlinebooks/group-as/asg1200e/aserefmn/@Generic__BookTextView/32650;pt=32654;lang=de#X

greetings,

Michael
0 Kudos
Reply
Sanjay Kumar Suri
Honored Contributor

‎01-11-2004 12:50 AM

‎01-11-2004 12:50 AM

Re: How to set up 2 GB of RAM for tempdb in Sybase

Check out the following link:
http://www.sybase.com/content/1023731/mtdb_wp.pdf

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.