HPE Community
Operating System - HP-UX
1752822 Members
4197 Online
108789 Solutions
New Discussion юеВ

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.