buffer_pool_services sqlbStartPools Probe:2

[viraboy]

Hello,
Trying to create new DMS TS, when run command to create receive error:

2004-04-20-16.23.16.444283 Instance:clldb201 Node:000
PID:8052(db2agent (CLLDB00)) Appid:*LOCAL.clldb201.040420201838
buffer_pool_services sqlbStartPools Probe:2 Database:CLLDB00

Tablespace 3 was mapped to BufferPool 2 which does not exist or
currently is the wrong pagesize.
It will be mapped to BufferPool 1.
if do db2stop/db2start using Instance owner and try again same command
works with no problem.

System info:
DB2 UDB 7.2.8 Linux/s390.
level:
DB21085I Instance "clldb201" uses DB2 code release "SQL07028" with
level
identifier "03090105" and informational tokens "DB2 v7.1.0.88",
"s030813" and
"MI00067".

Any idea / suggestion?

Thanks

[Matt Emmerton]

"viraboy" <vi*****@yahoo.com> wrote in message
news:14**************************@posting.google.c om...

Hello,
Trying to create new DMS TS, when run command to create receive error:

2004-04-20-16.23.16.444283 Instance:clldb201 Node:000
PID:8052(db2agent (CLLDB00)) Appid:*LOCAL.clldb201.040420201838
buffer_pool_services sqlbStartPools Probe:2 Database:CLLDB00

Tablespace 3 was mapped to BufferPool 2 which does not exist or
currently is the wrong pagesize.
It will be mapped to BufferPool 1.
if do db2stop/db2start using Instance owner and try again same command
works with no problem.

System info:
DB2 UDB 7.2.8 Linux/s390.
level:
DB21085I Instance "clldb201" uses DB2 code release "SQL07028" with
level
identifier "03090105" and informational tokens "DB2 v7.1.0.88",
"s030813" and
"MI00067".

Any idea / suggestion?

The error message seems to indicate that in your "create tablespace"
statement, you assigned the tablespace to a bufferpool that was the wrong
page size, so DB2 corrected it for you.

You need to create the appropriately-sized bufferpool before attempting to
create a tablespace with that page size.

--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab

[Matt Emmerton]

"viraboy" <vi*****@yahoo.com> wrote in message
news:14**************************@posting.google.c om...

Hello,
Trying to create new DMS TS, when run command to create receive error:

2004-04-20-16.23.16.444283 Instance:clldb201 Node:000
PID:8052(db2agent (CLLDB00)) Appid:*LOCAL.clldb201.040420201838
buffer_pool_services sqlbStartPools Probe:2 Database:CLLDB00

Tablespace 3 was mapped to BufferPool 2 which does not exist or
currently is the wrong pagesize.
It will be mapped to BufferPool 1.
if do db2stop/db2start using Instance owner and try again same command
works with no problem.

System info:
DB2 UDB 7.2.8 Linux/s390.
level:
DB21085I Instance "clldb201" uses DB2 code release "SQL07028" with
level
identifier "03090105" and informational tokens "DB2 v7.1.0.88",
"s030813" and
"MI00067".

Any idea / suggestion?

The error message seems to indicate that in your "create tablespace"
statement, you assigned the tablespace to a bufferpool that was the wrong
page size, so DB2 corrected it for you.

You need to create the appropriately-sized bufferpool before attempting to
create a tablespace with that page size.

--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab

[aka]

I had this problem when I created the bufferpool and then the tablespace in
a script. When I did a deactivate db and activate again between the create
bufferpool and create tablespace it works fine...
"viraboy" <vi*****@yahoo.com> schrieb im Newsbeitrag
news:14**************************@posting.google.c om...

Hello,
Trying to create new DMS TS, when run command to create receive error:

2004-04-20-16.23.16.444283 Instance:clldb201 Node:000
PID:8052(db2agent (CLLDB00)) Appid:*LOCAL.clldb201.040420201838
buffer_pool_services sqlbStartPools Probe:2 Database:CLLDB00

Tablespace 3 was mapped to BufferPool 2 which does not exist or
currently is the wrong pagesize.
It will be mapped to BufferPool 1.
if do db2stop/db2start using Instance owner and try again same command
works with no problem.

System info:
DB2 UDB 7.2.8 Linux/s390.
level:
DB21085I Instance "clldb201" uses DB2 code release "SQL07028" with
level
identifier "03090105" and informational tokens "DB2 v7.1.0.88",
"s030813" and
"MI00067".

Any idea / suggestion?

Thanks

[aka]

I had this problem when I created the bufferpool and then the tablespace in
a script. When I did a deactivate db and activate again between the create
bufferpool and create tablespace it works fine...
"viraboy" <vi*****@yahoo.com> schrieb im Newsbeitrag
news:14**************************@posting.google.c om...

Hello,
Trying to create new DMS TS, when run command to create receive error:

2004-04-20-16.23.16.444283 Instance:clldb201 Node:000
PID:8052(db2agent (CLLDB00)) Appid:*LOCAL.clldb201.040420201838
buffer_pool_services sqlbStartPools Probe:2 Database:CLLDB00

Tablespace 3 was mapped to BufferPool 2 which does not exist or
currently is the wrong pagesize.
It will be mapped to BufferPool 1.
if do db2stop/db2start using Instance owner and try again same command
works with no problem.

System info:
DB2 UDB 7.2.8 Linux/s390.
level:
DB21085I Instance "clldb201" uses DB2 code release "SQL07028" with
level
identifier "03090105" and informational tokens "DB2 v7.1.0.88",
"s030813" and
"MI00067".

Any idea / suggestion?

Thanks