Operating System - OpenVMS
1748185 Members
4026 Online
108759 Solutions
New Discussion юеВ

Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

 
SOLVED
Go to solution
Mario Dhaenens
Frequent Advisor

Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

Hi,

On one node in our VMS cluster I can't attach to a Rdb database called DSY.
The database can be opened on all other nodes.
But on one node I always get an error "no more user slots available".
It is a mixed cluster Alpha and I64 servers.
I have stopped/started the Rdb monitor on that specific node but without any results.


Error report:

SQL> att 'file dsy';
%SQL-F-ERRATTDEC, Error attaching to database dsy
-RDB-F-SYS_REQUEST, error from system services request
-RDMS-F-NOTSNBLK, no more user slots are available in the database

How can I see how many users are active on this DSY database?

All help is welcome.

/Toine
7 REPLIES 7
Wim Van den Wyngaert
Honored Contributor

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

NOTSNBLK, no more user slots are available in the database

Explanation: The maximum number of users are already accessing your
database.

Wim
Wim
Mario Dhaenens
Frequent Advisor

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

Hi,

It is very strange I have 500 user slots and only 400 are used.

On only one node I can't attach to the Rdb database.

/Toine
Wim Van den Wyngaert
Honored Contributor

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

I know almost nothing of RDB but in Sybase process and system parameters can limit the number of users (that's a nice formulation for "gets into rwast"). Check your documentation.
Or check if all rdb processes have enough free quota.

Wim
Wim
Karl Rohwedder
Honored Contributor
Solution

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

Hi Mario,
pls. note the text from metalink, esp. the last paragraph.

The NORTUPB and NOTSNBLK errors can occur under the following circumstances:

* 1) when your attach will exceed the maximum user count for the database

* 2) when you are trying to access the database from a node that does not have a TSNBLK allocated to it and there are no unallocated TSNBLKs available (regardless of maximum user count)

* 3) when the TSNBLK for your node is full and there are no unallocated TSNBLKs available (regardless of maximum user count)

When the first user on a node attaches to the database, a TSNBLK, if available, is allocated to that node. When that TSNBLK is full (28 attaches), a second TSNBLK, if available, is allocated to the node. Because of the way TSNBLKs are allocated to cluster nodes, sometimes it is not possible for the total number of users specified for the database to simultaneously attach to the database. A single user on NODEx causes a TSNBLK (and thus 28 user slots) to be allocated exclusively to NODEx.

A TSNBLK can not be reallocated to a different node until all attaches tracked in that TSNBLK have been terminated. This can result in NORTUPB or NOTSNBLK errors even though there would appear to be sufficient user and node count settings. For example, consider a database with a total of 3 TSNBLKs. Two TSNBLKs allocated to NODE1 are tracking 56 users. If 54 of those users detach, but the 2 remaining users are each in a different TSNBLK, users attaching from NODE2 would be limited to 28, since neither of the TSNBLKs allocated to NODE1 can be reused. The actual allocation of the TSNBLKs can be monitored with: RMU/SHOW STATISTICS -> Database Parameter Info -> TSNBLK Allocation

regards Kalle
Wim Van den Wyngaert
Honored Contributor

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

That's a nice feature. You are never sure how many users will get on the db.
I would oversize the number of users (e.g. 1000) and monitor the TSNBLK (with alarms).

Wim
Wim
Jan van den Ende
Honored Contributor

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

Mario,

from your Forum Profile:


I have assigned points to 25 of 40 responses to my questions.
, dating as far back as 2007.


Maybe you can find some time to do some assigning?

http://forums1.itrc.hp.com/service/forums/helptips.do?#33

Mind, I do NOT say you necessarily need to give lots of points. It is fully up to _YOU_ to decide how many. If you consider an answer is not deserving any points, you can also assign 0 ( = zero ) points, and then that answer will no longer be counted as unassigned.
Consider, that every poster took at least the trouble of posting for you!

To easily find your streams with unassigned points, click your own name somewhere.
This will bring up your profile.
Near the bottom of that page, under the caption "My Question(s)" you will find "questions or topics with unassigned points " Clicking that will give all, and only, your questions that still have unassigned postings.

Thanks on behalf of your Forum colleagues.

PS. nothing personal in this. I try to post it to everyone with this kind of assignment ratio in this forum. If you have received a posting like this before please do not take offence none is intended!

PPS. Zero points for THIS entry, please.

Proost.

Have one on me.

jpe
Don't rust yours pelled jacker to fine doll missed aches.
Mario Dhaenens
Frequent Advisor

Re: Rdb 7.2 RDMS-F-NOTSNBLK, no more user slots are available

Karl,

You solved my question.

I have 17 * 28 TSNBLK = 504 user slots.
So it is normal that I can't attach to this database on another node that has no TSNBLK allocated at the moment because the database is defined for a maximum user count of 500 users. I will change this to 1000 users.

Below some details:

Node: NVC (1/7/16) Oracle Rdb V7.2-310 Perf. Monitor 28-MAY-2009 23:15:59.81
Rate: 3.00 Seconds TSNBLK Allocation Elapsed: 00:08:44.59
Page: 1 of 2 DSY_RDB:[RDBDIR]DSY.RDB;1 Mode: Online
тАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФтАФ
BLK .Node. Rwtx RoTx NoTx Srvr Busy Free CommitTSN OldestTSN
0 NVE 0 1 27 0 28 0 0:284147767 0:283052109
1 NVA 0 0 28 0 28 0 0:284147777 0:0
2 NVD 3 1 24 0 28 0 0:284147577 0:283052165
3 NVD 0 0 28 0 28 0 0:283731144 0:0
4 NVD 0 0 28 0 28 0 0:282902105 0:0
5 NVD 5 0 23 0 28 0 0:284082756 0:284147694
6 NVL 0 0 28 0 28 0 0:283256360 0:0
7 NVL 0 0 7 0 7 21 0:283992435 0:0
8 NVJ 0 1 27 0 28 0 0:284147770 0:283052578
9 NVJ 1 0 27 0 28 0 0:284075899 0:283052834
10 NVA 0 0 20 0 20 8 0:283046417 0:0
11 NVJ 0 0 28 0 28 0 0:282816489 0:0
12 NVE 8 0 18 0 26 2 0:284102495 0:284144852
13 NVJ 1 0 27 0 28 0 0:284147215 0:284064423
14 NVR 0 0 1 0 1 27 0:284146123 0:0
15 NVJ 0 0 2 0 2 26 0:282756204 0:0
16 NVD 0 1 5 0 6 22 0:283469911 0:283052834
17 NVE 1 0 2 0 3 25 0:284115956 0:284146673

Thank you


/Toine