Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

what is this error ?

  
   Database Forums (Home) -> DB2 RSS
Next:  db2 to oracle migration  
Author Message
Roger

External


Since: Apr 27, 2007
Posts: 9



(Msg. 1) Posted: Sun Jan 20, 2008 6:42 pm
Post subject: what is this error ?
Archived from groups: comp>databases>ibm-db2 (more info?)
I see a lot of dump file with this kind of messages on the db2dump
path, what is this ? I looked up SQL0820N, it says the is some
connector exceeding its limit. How can I find out what the limit is
and how I can change it ?
Any help will be appreciated

Thanks



TFAST
s0707202007-01-12-16.47.23.761007ÿÿþì **** DRDA ASCB ****ÌÌÌÌÏ°
DB2 DRDA
ASµÝà·øþy»ää°ÿÿÿÿÿÿϼÀϼÀ
ÄÏϸϰÈÄÏϸϰÈÏ»ÿd
$t$@ÄÏÏavaw.exe 136C12CC010HARVEST+0000ALLAN
DB2 SQL08020NT javaw.exe allan
SQL08020L3CB120D01 f=ø(Xÿÿÿÿ6hÿÿÿÿÿ )}Ø! @µÝàϼ@ÿÿ
ϼϼϼϼ¸É¸É¸~ÿ5I¶¶ù**0TCP/IPSOCKETS10.151..80.148recvTFAST
s0707202007-01-12-16.47.23.762656ÿÿþë**** DRDA CMNMGR CB
****ÌÌÌÌÏ )}Ø!
@µÝàϼ@ÿÿ
ϼϼϼϼ¸É¸É¸~ÿ5I¶¶ù**0TCP/IPSOCKETS10.151..80.148recvTFAST
s0707202007-01-12-16.47.23.762781ÿÿþë**** RECEIVE BUFFER
****ÌÌÌ̶TFAST
/ØãÄâØÓÁâÃÐS01-10-16.47.23.762900ÿÿþë**** SEND BUFFERS ****ÌÌÌ̸Ê&ÐR
"!@@@@@@@@@@@@@@@@@@ÐS
5¸Ð{ÿ08001SQLJCMN 6
(*ÿ*ÿ0ÿTCP/IPÿSOCKETSÿ10.151.80.148ÿrecvÿÿÌÌÌÌÌÌTFAST
s0707202007-01-12-16.47.23.763030ÿÿþì **** CONNECTION HANDLE
****ÌÌÌ̵Ýà@ Gæý`µà@A@ÿÿÿÿÿØN TFAST
s0707202008-01-10-16.47.23.763152ÿÿþì **** DRDA ATTRIBUTES ****ÌÌÌÌÄ
ôøTFAST
s0707202007-01-12-16.47.23.763270ÿÿþì **** AS UCINTERFACE
****ÌÌÌ̵à@PµÝà GæµÂhµâ Ï° )@A » FUNCTION ID = 0004 , PROBE
POINT
= 0001 , TRACE POINT = 0040 , SUBCODE1 = FFFFFFFF81360068, SUBCODE2 =
FFFFFFFFFFFF8A7F, SUBCODE3 = 0000000000000000, ERROR MSG = AGENT:
CMNMGR
Send fail

 >> Stay informed about: what is this error ? 
Back to top
Login to vote
Larry3

External


Since: Dec 09, 2003
Posts: 113



(Msg. 2) Posted: Sun Jan 20, 2008 11:44 pm
Post subject: Re: what is this error ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Try typing

DB2 ? Error msg #

in a db2 command window. In this case

DB2 ? SQL08020N

and you get:

Explanation:

The number of concurrent connectors has exceeded the number of
defined entitlements.

User Response:

Contact your IBM representative or authorized dealer to obtain
additional entitlements and then update the DB2 license
information in the License Center.

Sounds like you are licensed by concurrent user and you exceeded the
maximum concurrent users that you are licensed for.

Larry E.

Roger wrote:
> I see a lot of dump file with this kind of messages on the db2dump
> path, what is this ? I looked up SQL0820N, it says the is some
> connector exceeding its limit. How can I find out what the limit is
> and how I can change it ?
> Any help will be appreciated
>
> Thanks
>
>
>
> TFAST
> s0707202007-01-12-16.47.23.761007ÿÿþì **** DRDA ASCB ****ÌÌÌÌÏ°
> DB2 DRDA
> ASµÝà·øþy»ää°ÿÿÿÿÿÿϼÀϼÀ
> ÄÏϸϰÈÄÏϸϰÈÏ»ÿd
> $t$@ÄÏÏavaw.exe 136C12CC010HARVEST+0000ALLAN
> DB2 SQL08020NT javaw.exe allan
> SQL08020L3CB120D01 f=ø(Xÿÿÿÿ6hÿÿÿÿÿ )}Ø! @µÝàϼ@ÿÿ
> ϼϼϼϼ¸É¸É¸~ÿ5I¶¶ù**0TCP/IPSOCKETS10.151..80.148recvTFAST
> s0707202007-01-12-16.47.23.762656ÿÿþë**** DRDA CMNMGR CB
> ****ÌÌÌÌÏ )}Ø!
> @µÝàϼ@ÿÿ
> ϼϼϼϼ¸É¸É¸~ÿ5I¶¶ù**0TCP/IPSOCKETS10.151..80.148recvTFAST
> s0707202007-01-12-16.47.23.762781ÿÿþë**** RECEIVE BUFFER
> ****ÌÌÌ̶TFAST
> /ØãÄâØÓÁâÃÐS01-10-16.47.23.762900ÿÿþë**** SEND BUFFERS ****ÌÌÌ̸Ê&ÐR
> "!@@@@@@@@@@@@@@@@@@ÐS
> 5¸Ð{ÿ08001SQLJCMN 6
> (*ÿ*ÿ0ÿTCP/IPÿSOCKETSÿ10.151.80.148ÿrecvÿÿÌÌÌÌÌÌTFAST
> s0707202007-01-12-16.47.23.763030ÿÿþì **** CONNECTION HANDLE
> ****ÌÌÌ̵Ýà@ Gæý`µà@A@ÿÿÿÿÿØN TFAST
> s0707202008-01-10-16.47.23.763152ÿÿþì **** DRDA ATTRIBUTES ****ÌÌÌÌÄ
> ôøTFAST
> s0707202007-01-12-16.47.23.763270ÿÿþì **** AS UCINTERFACE
> ****ÌÌÌ̵à@PµÝà GæµÂhµâ Ï° )@A » FUNCTION ID = 0004 , PROBE
> POINT
> = 0001 , TRACE POINT = 0040 , SUBCODE1 = FFFFFFFF81360068, SUBCODE2 =
> FFFFFFFFFFFF8A7F, SUBCODE3 = 0000000000000000, ERROR MSG = AGENT:
> CMNMGR
> Send fail

 >> Stay informed about: what is this error ? 
Back to top
Login to vote
Roger

External


Since: Apr 27, 2007
Posts: 9



(Msg. 3) Posted: Mon Jan 21, 2008 4:03 pm
Post subject: Re: what is this error ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Larry, I did look up that error message, but what concurrent
connectors is it talking about ? I run DB2 on CPU based license not
concurrent users. How can I find out what is the limit that its
hitting ? Where is it set ? A db2licm -l shows that I am on
Processor license.

Thanks
 >> Stay informed about: what is this error ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
DB2 error on AIX - i am working with db2 8.1 and when i log on as db2inst1 and issue the comand db2 for db2 prompt it gives me following error DB21015E The Command Line Processor backend process request queue or input queue was not created within the timeout period. db...

DB2 Error - Exception EDBEngineError in module Cserv.exe at 0013E2C8. General SQL error. [IBM][CLI Driver][DB2/NT]SQL0727N An error occurred during implicit system action type "1". Information returned for the error includes SQLCODE "-101", SQLST...

TCP/IP Error, rc1=22 - ENVIRONMENT: ________________________________________________________ "Server 1" = DB2 UDB ESE 7.1 FP7 on AIX 5.1 "Server 2" = DB2 UDB ESE 8.1 FP2 on AIX 5.1 ________________________________________________________ SCENARIO:..

SQL error - i get this error SQL30020N when selecting data from a table . I altered this table earlier today when i do it a select * from the table query runs OK, but when i join this table with 10 other tables (in a scheduled job) i get this error. The job has bee...

sql error -530 - Ist this possible to get the causing column for a sql error -530 (foreign key) in an insert command? What I mean: evaluate sqlcode if -530 if causing_column = "Model" .... end if if causing_column = "Group" .....
   Database Forums (Home) -> DB2 All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]