<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<p class="MsoNormal"><b><span style="color:red">I am having the below issue with
one subscriber “my setup is one publisher and two subscribers”</span></b></p>
<p class="MsoNormal"><b><span style="color:red"> </span></b></p>
<p class="MsoNormal"><b><span style="color:red">From the Publisher I have the
below:</span></b></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">admin:utils dbreplication runtimestate </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">DB and Replication Services: ALL RUNNING</p>
<p class="MsoNormal">Cluster Replication State: BROADCAST SYNC Completed on 1
servers at: 2013-01-24-19-11</p>
<p class="MsoNormal"> Last Sync Result: SYNC
COMPLETED 541 tables sync'ed out of 541</p>
<p class="MsoNormal"> Sync Errors: 1 Errors or failures
were found</p>
<p class="MsoNormal"> Use this command to see the output
- file view activelog
/cm/trace/dbl/2013_01_24_19_10_13_dbl_repl_cdr_Broadcast.log</p>
<p class="MsoNormal">DB Version: ccm8_6_2_22900_9</p>
<p class="MsoNormal">Number of replicated tables: 541</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Cluster Detailed View from PUB (3 Servers):</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">
PING
REPLICATION REPL. DBver&
REPL. REPLICATION SETUP</p>
<p class="MsoNormal">SERVER-NAME IP
ADDRESS (msec) RPC?
STATUS QUEUE
TABLES LOOP? (RTMT) & details </p>
<p class="MsoNormal">-----------
------------ ------ ----
----------- ----- ------- -----
-----------------</p>
<p class="MsoNormal">PUB 10.x.x.x
0.033 Yes
Connected
0 match
Yes (2) PUB Setup Completed</p>
<p class="MsoNormal">SUB01 10.x.x.y
0.115 Yes
Connected
0 match
Yes (2) Setup Completed</p>
<p class="MsoNormal">SUB02 10.x.x.z
0.107 Yes
Off-Line N/A
0 N/A (0) Not
Setup </p>
<p class="MsoNormal">admin:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b><span style="color:red">and on the publisher I see this
for the 2<sup>nd</sup> subscriber I am having an issue with</span></b></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">admin:file view activelog cm/log/informix/ccm.log</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">19:16:17 Password Validation for user [dblpm] failed!</p>
<p class="MsoNormal">19:16:17 Check for password aging/account lock-out.</p>
<p class="MsoNormal">19:16:17 listener-thread: err = -952: oserr = 0:
errstr = dblpm@SUB02: User (dblpm@SUB02)'s password is not correct for the
database server.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">19:16:17 Password Validation for user [dbmon] failed!</p>
<p class="MsoNormal">19:16:17 Check for password aging/account lock-out.</p>
<p class="MsoNormal">19:16:17 listener-thread: err = -952: oserr = 0:
errstr = dbmon@SUB02: User (dbmon@SUB02)'s password is not correct for the
database server.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">19:16:17 Password Validation for user [dbris] failed!</p>
<p class="MsoNormal">19:16:17 Check for password aging/account lock-out.</p>
<p class="MsoNormal">19:16:17 listener-thread: err = -952: oserr = 0:
errstr = dbris@SUB02: User (dbris@SUB02)'s password is not correct for the
database server.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">19:16:19 Password Validation for user [dbauditlog]
failed!</p>
<p class="MsoNormal">19:16:19 Check for password aging/account lock-out.</p>
<p class="MsoNormal">19:16:19 listener-thread: err = -952: oserr = 0:
errstr = dbauditlog@SUB02: User (dbauditlog@SUB02)'s password is not correct
for the database server.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">19:16:20 Password Validation for user [dbmon] failed!</p>
<p class="MsoNormal">19:16:20 Check for password aging/account lock-out.</p>
<p class="MsoNormal">19:16:20 listener-thread: err = -952: oserr = 0:
errstr = dbmon@SUB02: User (dbmon@SUB02)'s password is not correct for the
database server.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">options: q=quit, n=next, p=prev, b=begin, e=end (lines 1 -
20 of 5708) : </p>
<p class="MsoNormal">admin:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b><span style="color:red">I am sure that security password
is the same everywhere, what do you think the problem is?</span></b></p>
<p class="MsoNormal"> </p><br><div><font color="#000000">Thanks,</font><br><font color="#000000">Ahmed Elnagar</font><br><br></div> </div></body>
</html>