Add a way to wait for bufferpool creation when creating tablespaces

What we do when creating tablespaces as part of migration files (think flyway, but any similar utility will be relevant) is to create a bufferpool and then create the tablespace. Example:

create bufferpool dummy
size 5000
pagesize 8k;

create tablespace dummy
pagesize 8192
managed by automatic storage
autoresize yes
initialsize 200 M
extentsize 64
prefetchsize 128
bufferpool dummy;

Problem is that more often than not, the bufferpool is not ready to be used when the tablespace is created. This means that the tablespace will be using - in this example - IBMSYSTEMBP8K until next time Db2 allocates bufferpools, say after db2stop; db2start.

Our current workaround is to add a sleep and a commit (in the case of flyway this can be achieved by creating the bufferpool in a separate migration file), example:

cat file_1

create bufferpool dummy2
size 5000
pagesize 8k;

call DBMS_LOCK.SLEEP(10);

cat file_2

create tablespace dummy2
pagesize 8192
managed by automatic storage
autoresize yes
initialsize 200 M
extentsize 64
prefetchsize 128
bufferpool dummy2;

This is however error prune since the amount of time needed to allocate the bufferpool varies with the size and the amount of resources like cpu availible at the server. AFAIK there is no way to tell if the bufferpool is ready to be used or not. Two possible ways for a solution would be:

A procedure that can be called:

cat file_1

create bufferpool dummy ....;

CALL WAIT_FOR_BP_CREATION('DUMMY2');

cat file_2

create tablespace dummy2 ...;

Add an option in create tablespace statement:

create tablespace dummy2

...

bufferpool dummy2 WITH WAIT;

In my experiments, both the sleep and the commit is necessary to prevent the phenomena, but I'm not sure if that is just bad luck. I don't think it would be a good idea to do an implicit commit in any of these suggestions, but perhaps a note of the necessity of a commit (if that is the case) could be added to the documentation.

FWIW, there is an old thread at https://dba.stackexchange.com/questions/262775/new-bufferpool-not-being-used and also https://chat.stackexchange.com/rooms/106007/discussion-between-lennart-and-mark-barinstein where this phenomena is discussed