Ok, I do have a few questions. I put down this:
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0001 R 62500
but it should actually be this:
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3 R 62500
Now to explain the parts:
1 --> Is the number of devspaces that will be put on this partition or
slice.
DATA --> Is the type of devspace.
dev/rdsk/c0t9d0s3 --> Is the raw slice/partition that I'm using.
R --> Is the type of partition, in my case I'm using raw partitions for
just data and log, but not sys is that right?
62500 --> Is the size of each devspace that is being created.
Now, my questions are. Should I just use one raw partition pre disk, I say
yes, Is that right? Should I use multiple devspaces on that raw partition,
so for example if I had a 2GB partition, should I create one devspace of
2GB for that partition or should I create four 500MB devspaces on that raw
partition to make for better access time? Does that even matter for raw
devspaces? As you can tell, I've never really used raw partitions, and I
hate to do anything that I don't fully understand. I have a db running now
on raw partitions, but I want to make sure I understand completely before
creating a production db to start using.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
"Vorsprach, Bernd"
<[EMAIL PROTECTED]> To:
[EMAIL PROTECTED]
Sent by: cc:
sapdb.general-admin@lists Subject: RE: Creating a DB?
Disregard, I've got most of it figured out.
erv.sap.com
04/10/02 01:26 AM
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> I took a break and started in again. I believe I have it figured out.
> I just have simple questions:
> The way I understand it, I only need one devspace per disk if I'm
> using raw devspace. Is this correct?
Yes there is no reason to split a disk in more than one devspace.
[...]
> param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0001 R 62500
> param_adddevspace 1 DATA dev/rdsk/c0t11d0s1/$SID/DATA0002 R 62500
[...]
You have to increase the devspace number in the command
param_addddevspace:
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0001 R 62500
param_adddevspace 2 DATA dev/rdsk/c0t11d0s1/$SID/DATA0002 R 62500
param_adddevspace 3 DATA ...
param_adddevspace 1 LOG dev/rdsk/c0t9d0s1/$SID/LOG001 R 31250
param_adddevspace 2 LOG dev/rdsk/c0t11d0s0/$SID/LOG002 R 31250
Bernd
--
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
