-----Original Message----- > From: Martin Kittel > > Hi Don, > > > -----Original Message----- > > From: Don Gray [mailto:[EMAIL PROTECTED] > > > > When I defined the instance I told it to use a max > > of 16 data files and defined the first file as having 5Gb... > > You might try to use data files of sizes < 2GB. Although MaxDB supports file sizes > greater than 2GB there still might be the problem of your filesystem not supporting it. > > Good luck, > > Martin. > SAP Labs, Berlin.
Martin, Thank you very much that allowed me to create the instance. I specified 1Gb data files. >From everything I have read and have been able to determine, RedHat Enterprise 3.0 (based on RH 9.0) SHOULD support files greater than 2Gb. In fact in some cursory testing that I did I was able to create greater than 2.1Gb files using simple system utilities. -rw-r--r-- 1 root root 2561325100 Jan 20 08:02 bigfile3 Is this perhaps some limit imposed by the seeming requirement to run with LD_ASSUME_KERNEL=2.2.5? Or is it some limit imposed by the version of C libraries that MaxDB has been compiled against? Note that I installed compat-libstdc++-7.3-2.96.118.i386.rpm in order to allow the SDBINST script to complete its install... I got errors otherwise. Being unfamiliar with MaxDB, I have significant concerns regarding this work around. I anticipate that my databases working size will be in the 75Gb range. Is it a performance concern to have 75 1Gb files as opposed to 15 5Gb files? It seems that it would become an administrative issue in the least. Thanks for any insight. Don Gray CTO, VigilantMinds Inc. -----Original Message----- From: Don Gray Sent: Tuesday, January 20, 2004 12:56 AM To: '[EMAIL PROTECTED]' Subject: MaxDB Newbie - Can't Set Instance Online Installing MaxDB on Whitebox Linux 3.0 (RH AS 3.0 - knockoff) After much work... Thank you mailing list archives! I have gotten MaxDB 7.5 installed and running. I am trying to create my first instance and am using the GUI wizard tool. I defined the instance and all seems well. I can set the instance to ADMIN fine. When I try to take it online I get the following error: -24985 shutdown of database occurred [db_online -f]; -71, connection broken server state 6 Here is a snippet of the knldiag.err file: 2004-01-19 19:30:57 2952 ERR 146 RTE UNIX change owner with chown(DAT_0001,501,501) failed: No such file or directory 2004-01-19 19:30:57 2952 ERR 14 IOMan Attach error on Data volume 1: Cannot set support group for volume 2004-01-19 19:30:57 2952 ERR 8 Admin ERROR 'disk_not_accessibl' CAUSED EMERGENCY SHUTDOWN 2004-01-19 19:30:57 2952 12696 DBSTATE Change DbState to 'SHUTDOWN'(25) So it looks like it can't create DAT_0001??? How exactly do the data files get created? When I defined the instance I told it to use a max of 16 data files and defined the first file as having 5Gb... Am I missing a step? Very confused... Don Gray CTO, VigilantMinds Inc. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
