Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Kelvin Yu
Advisor

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
2 REPLIES
Michael Schulte zur Sur
Honored Contributor

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
Sanjay Kumar Suri
Honored Contributor

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.