Block size error on Database creation

Question

Question

Ashok Kumar · Oct 19, 2023

#Databases #System Administration #InterSystems IRIS

Hello Community,

I got the below error while creating a new database.

Product version: IRIS 2023.2

$ZV: IRIS for Windows (x86-64) 2023.2 (Build 227)

Discussion (7)2

Log in or sign up to continue

Dmitry Maslennikov · Oct 19, 2023

Ahh, yes, you also need some Global Buffer for this size too

1 0

score 1 · Answer 1 · 2023-10-19T06:40:16-04:00

Luis Angel Pére... · Oct 19, 2023

Check this page from the documentation.

1 0

score 1 · Answer 2 · 2023-10-19T06:53:14-04:00

Dmitry Maslennikov · Oct 19, 2023

Just need to enable it in settings

1 0

score 0 · Answer 3 · 2023-10-19T07:09:04-04:00

Hello @Dmitry Maslennikov
I had enabled the options and restarted the iris before creating the database. Still I got the error

score 0 · Answer 4 · 2023-10-19T09:30:21-04:00

Thanks @Dmitry Maslennikov

It works. I thought "Initial (25% of physical memory)" of the global buffer will also applicable for other block size. However It's not that kind. There is default 0 for those blocks. So, it's mandatory to make it specific amount.

Once I made the changes it works!

score 1 · Answer 5 · 2023-10-20T14:17:38-04:00

I'd love to know more about your specific use case for using 32KB blocks for the database. In my experience, 8KB blocks are generally more adaptable unless you're exclusively working with atomic data elements that are that size or larger. IMHO, it's an instance wide consideration rather than only a database level consideration because allocating buffers of 32KB reserves a portion of the memory for blocks of that size.

score 1 · Answer 6 · 2023-10-22T21:47:05-04:00

Hello @Chad Severtson

We have streams to store it for long time. So, As per the documentation. I was thinking to to create a separate database to move the existing streams, create a new streams and maintain it accordingly. Can you add bit more details about this the instance wide consideration rather than only a database level consideration because allocating buffers of 32KB reserves a portion of the memory for blocks of that sizeHow much memory is allocated and how to calculate it

Thanks!