Question Re: Directory Server Free Space in Technology Q&A

Directory Server Free Space

JimDiaz — Tue, 29 Jan 2019 07:18:29 GMT

I am using a directory server which does not exist on the same drive as any of the database files. Is there any way to query the space available on the drive before inserting into a table on the drive to see if there is room?

Thanks

Jim

Re: Directory Server Free Space

VolkerBarth — Tue, 29 Jan 2019 07:50:41 GMT

When using SQL Anywhere 17, you can use the sp_disk_info() system procedure.

On Windows, this can be used both with directories on drives identified by drive letters or UNC names. Don't know how this works on Unixes.

-- note, need do specify an existing file/dir (here the root dir)
call sp_disk_info('C:\\\\.');
-- UNC (seems to expect an existing dir or file other than the root dir
call sp_disk_info('\\\\\\\\ServerName\\\\Netshare\\\\AnExistingDir');

Re: Directory Server Free Space

JimDiaz — Tue, 29 Jan 2019 08:15:59 GMT

Any options on 12 or 16 we are not up to 17 yet.

Re: Directory Server Free Space

Breck_Carter — Tue, 29 Jan 2019 08:47:29 GMT

See this topic about using WMIC: Check free disk space using Batch commands.