RE: Problem with Control Center communicating with Linux Server

RE: Problem with Control Center communicating with Linux Server

 

  

Well I am getting closer to fixing my problem. I found out few things were
set up incorrectly just from playing around and looking into different
newsgroups. First I did not have an entry into the /etc/services file on the
linux server. So I added an entry called DASPORT 40000/tcp. I had the DBM
CFG for SVCENAME set to 40000. I changed this to DASPORT. I rebooted the
server. Once I did that I went into Control Center and I was able to FINALLY
create a database. By the way before I made that change I was able to create
a database from the server db2 command line (as Daniel Callahan asked me
to). I was happy to be able to finally get this far with the Control Center.
But that excitement quickly vanished when I tried to go to the next step of
creating a table. When attempting to create a table I got error SQL22212N.
Also if I tried to go into Configuration Advisor or Configure Database
logging I got SQL4414N saying the Database Server is not active. I am sure
it is active on the server but it must be pointing to the setup of the ADMIN
TCPIP Node I am thinking. Has anyone gotten the combination of these two
errors SQL22212N SQL4414N and found a solution?

David




>From: "David Cuffee "
><db2udbdba-ezmlmshield-x93144851.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Problem with Control Center communicating with Linux Server
>Date: Mon, 16 Aug 2004 21:17:51 +0000
>
>That did not work. Now I am getting SQL22201N reason code "1" invalid
>username/password whenever it asks for a password.
>
>David
>
>
> >From: "Praveen Chengalathu "
> ><db2udbdba-ezmlmshield-x87097822.[Email address protected]
> >To: "LazyDBA Discussion" <[Email address protected]
> >Subject: RE: Problem with Control Center communicating with Linux Server
> >Date: Mon, 16 Aug 2004 18:29:45 +0100
> >
> >Try this combination.
> >
> >db2 dbm cfg using AUTHENTICATION CLIENT
> >db2 dbm cfg using TRUST_ALLCLNTS YES
> >db2 dbm cfg using TRUST_CLNTAUTH SERVER
> >
> >-----Original Message-----
> >From: David Cuffee
> >[mailto:db2udbdba-ezmlmshield-x1555227.[Email address protected]
> >Sent: 16 August 2004 18:21
> >To: LazyDBA Discussion
> >Subject: Problem with Control Center communicating with Linux Server
> >
> >
> >More GET DBM CFG (last page):
> >
> >Directory cache support (DIR_CACHE) = YES
> >
> >Application support layer heap size (4KB) (ASLHEAPSZ) = 15
> >
> >Max requester I/O block size (bytes) (RQRIOBLK) = 32767
> >
> >Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
> >
> >DRDA services heap size (4KB) (DRDA_HEAP_SZ) = 128
> >
> > Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 100
> >
> > Priority of agents (AGENTPRI) = SYSTEM
> >
> >Max number of existing agents (MAXAGENTS) = 400
> >
> >Agent pool size (NUM_POOLAGENTS) =
> >
> >200(calculated)
> >
> >Initial number of agents in pool (NUM_INITAGENTS) = 0
> >
> >Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS -
> >NUM_INITAGENTS)
> >
> >Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
> >
> >Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS
> >
> > Keep fenced process (KEEPFENCED) = YES
> >
> >Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS
> >
> >Initial number of fenced processes (NUM_INITFENCED) = 0
> >
> > Index re-creation time (INDEXREC) = RESTART
> >
> > Transaction manager database name (TM_DATABASE) = 1ST_CONN
> >
> >Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
> >
> > SPM name (SPM_NAME) =
> >
> >SPM log size (SPM_LOG_FILE_SZ) = 256
> >
> >SPM resync agent limit (SPM_MAX_RESYNC) = 20
> >
> >SPM log path (SPM_LOG_PATH) =
> >
> > TCP/IP Service name (SVCENAME) = 40000
> >
> >Discovery mode (DISCOVER) = SEARCH
> >
> >Discover server instance (DISCOVER_INST) = ENABLE
> >
> > Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
> >
> >Enable intra-partition parallelism (INTRA_PARALLEL) = NO
> >
> > No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
> >
> >Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
> >
> >Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
> >
> >Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
> >
> > Node connection elapse time (sec) (CONN_ELAPSE) = 10
> >
> >Max number of node connection retries (MAX_CONNRETRIES) = 5
> >
> >Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
> >
> > db2start/db2stop timeout (min) (START_STOP_TIME) = 10
> >
> >
> >---------------------------------------------------------------------
> >PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> >website: http://www.LazyDBA.com
> >To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >**********************************************************************
> >This email and any files transmitted with it are confidential and are
> >intended solely for the use of the individual or entity to whom they are
> >addressed. This communication represents the originator's personal views
> >and
> >opinions, which do not necessarily reflect those of HPI Limited. If you
>are
> >not the original recipient or the person responsible for delivering the
> >email to the intended recipient, be advised that you have received this
> >email in error, and that any use, dissemination, forwarding, printing, or
> >copying of this email is strictly prohibited. If you received this email
>in
> >error, please immediately notify [Email address protected]
> >
> >This message has been scanned by Panda Anti-Virus. Recipients are advised
> >to
> >apply their own virus checks to this message on delivery.
> >**********************************************************************
> >
> >
> >
> >
> >---------------------------------------------------------------------
> >PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> >website: http://www.LazyDBA.com
> >To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
>
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>website: http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page