Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert "Main IQ blocks used" to Mb value

Status
Not open for further replies.
Zahier

Zahier

MIS
Oct 3, 2002
97
ZA
Hi DBA's,

I am putting in scripts to check the space usage in my IQ server. I can use the percentage value to determine a threshold, but would like to know how to get the Mb equivalent. I.e How many bytes is one IQ block equal to?

I created a formula but it returns inconsistent results.

Tx
:)
 
Sort by date Sort by votes
Seems I had finger trouble.

I get a value of 256Mb per block. Is this an Sybase IQ standard, or is this configurable to a smaller block size?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
169
AM_WG
AM_WG
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
122
raphael75
raphael75
stropiccioli
  • Locked
  • Question
Sybase PB12.5 and oracle 11g "Oracle library OCI.DLL could not be loaded"
Replies
0
Views
111
stropiccioli
stropiccioli
skibear99
  • Locked
  • Question
Select "All Records"
Replies
1
Views
92
PDreyer
PDreyer
baltman
  • Locked
  • Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
126
baltman
baltman

Part and Inventory Search

Sponsor

Back
Top