on 02-12-2015 3:08 PM
Hi All,
Could you please help me to know if VxFS is still unsupported with SQLA 12 and/or 16
Thanks
PrashantJ
Message was edited by: Jeff Albion - Adjusted title to reflect question / SQLA
Hi Prashant,
All of our I/O requirements are specified in our SQL Anywhere I/O Requirements whitepaper - SQL Anywhere is generally file system agnostic and can be stored on a wide variety of media devices (SAN, NAS, etc.).
The basic requirements are that the database servers require write-ordering and write-through support. Any writes should be backed by a battery-powered memory cache if not being written out immediately.
If you're running RedHat Linux, there is also a known issue with direct I/O on some kernel versions - see:
If you're "virtualizing" any part of the I/O subsystem, see SAP's general support statement for virtualized environments in KBA 1492000. As long as it's transparent to the host operating system, we will support it.
Regards,
Jeff Albion
SAP Active Global Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prashant,
We don't have explicit file system type support in SQL Anywhere, but yes VxFS is "supported" - we have other customers who can run on this file system type successfully.
As I mentioned above, we are generally file system/device agnostic. On UNIX / Linux, we will try to open files for write using the O_DIRECT flag for direct I/O operations against the file, but this may not be supported by all file system types. If this happens and O_DIRECT isn't supported, you will see the message:
Direct IO disabled for file '%1' because the file system on which it resides does not support it.
Regards,
Jeff Albion
SAP Active Global Support
HI Prashant,
Do you have any specific suporting doc which talking about VXFS veritas file system
No, not specifically since we state support for SQL Anywhere in terms of the operating system as a whole rather than the specific file systems that can be used with the operating system. See our Supported Platforms page:
SQL Anywhere uses standard file POSIX calls on Linux / UNIX, so again, the underlying file system type just needs to support our file semantics (write-through and write-ordering).
Regards,
Jeff Albion
SAP Active Global Support
Did you mean VSS by any chance?
SQL Anywhere Volume Shadow Copy Service (VSS)
The only VFS I know of in a SQLA content is the file system for Palm devices.
Thanks
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK, I'll bite... what's VFS? ...some kind of virtual file system?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.