PLEASE HELP! CDR on NT4
Posted in 1998
This is a multi-part message in MIME format.
--------------C8A86857803A616BA6E48F61
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Has anyone successfully implemented CDR on NT4?
I'm using ODS 7.23, Enterprise Rep. Mgr. on NT4, SP3, 128 MB ram.
Everytime I start CDR on Enterprise Rep. Mgr. Dr. Watson Pops up saying
thers is an Access violation on SNMP.exe. Then the SNMP service goes
down.
I've already tried it in 3 diff. machines, each executing the same
behavior.
ERM Error: SNMP connection has timed out!
I've read all there is to be read regarding the subject.
Installed SNMP agents and subagents, modified SQLHOSTS, ONCONFIG alias,
copied mib.bin from informix\\etc to winnt\\system32, modified the
SERVICES file
so that every server has a unique port number, modified HOSTS file,
etc...
My rephosts file looks like:
IER_group_z group - - i=20
IER_ol_zandy olsoctcp zandy turbozz g=IER_group_z
IER_group_n group - - i=10
IER_net_online olsoctcp it-jtm turbo1 g=IER_group_n
IER_group_g group - - i=30
IER_ol_george olsoctcp george turbogg g=IER_group_g
CDR initialization is fine as shown in my online.log:
21:11:29 DR: DRAUTO is 0 (Off)
21:11:37 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
21:11:37 Physical Recovery Started.
21:11:37 Physical Recovery Complete: 0 Pages Restored.
21:11:37 Logical Recovery Started.
21:11:40 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
21:11:40 Dataskip is now OFF for all dbspaces
21:11:41 Init operation complete - Mode Online
21:11:41 On-Line Mode
21:11:54 Checkpoint Completed: duration was 1 seconds.
21:11:55 no proper group entry <ol_zandy> for <x=ol_zandy>
21:11:55 CDR Schedule Manager initialization complete.
21:11:56 CDR catalog verification (repdef)
21:11:56 CDR catalog verification (partdef)
21:11:56 CDR catalog verification (servdef)
21:11:56 CDR catalog verification (pendingstates)
21:11:56 CDR catalog verification (cdr_errors)
21:11:56 CDR catalog verification (trg_sendq)
21:11:56 CDR catalog verification (control_sendq)
21:11:57 CDR catalog verification (replaytab)
21:11:57 CDR catalog verification (progtab)
21:11:57 CDR catalog verification (receivedup)
21:11:57 CDR catalog verification (collectdef)
21:11:57 CDR catalog verification (collpartdef)
21:11:57 CDR catalog verification (cdrstate)
21:11:57 CDR catalog verification (deltabdef)
21:11:57 CDR catalog verification (deltabrep)
21:11:57 CDR catalog verification (logevent)
21:11:57 CDR catalog verification (freqdef)
21:11:57 CDR Catalogs verification complete
21:11:57 CDR GC: catalog recovery begin
21:11:57 no proper group entry <ol_zandy> for <x=ol_zandy>
21:11:58 CDR GC: server recovery complete
21:11:58 CDR GC: replicate recovery complete
21:11:58 CDR GC: replicate pending state recovery complete
21:11:58 CDR GC: group recovery complete
21:11:58 CDR GC: group pending state recovery complete
21:11:58 CDR GC: catalog recovery complete
21:11:58 Queuer Initialization was successful
21:11:59 CDR NIF 1 User User Counters created.
Attached is my SQLHOSTS registry file exported.
Is ther a caveat somewhere? Please help ....
Zandy Marantal
--------------C8A86857803A616BA6E48F61
Content-Type: text/plain; charset=us-ascii; name="sqlhosts.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="sqlhosts.txt"
REGEDIT4
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts]
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_group_g]
"HOST"="-"
"OPTIONS"="i=30"
"PROTOCOL"="group"
"SERVICE"="-"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_group_g\\IER_ol_george]
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_group_n]
"HOST"="-"
"OPTIONS"="i=10"
"PROTOCOL"="group"
"SERVICE"="-"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_group_n\\IER_net_online]
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_group_z]
"HOST"="-"
"OPTIONS"="i=20"
"PROTOCOL"="group"
"SERVICE"="-"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_group_z\\IER_ol_zandy]
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_net_online]
"HOST"="it-jtm"
"OPTIONS"="g=IER_group_n"
"PROTOCOL"="olsoctcp"
"SERVICE"="turbo1"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_ol_george]
"HOST"="george"
"OPTIONS"="g=IER_group_g"
"PROTOCOL"="olsoctcp"
"SERVICE"="turbogg"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\IER_ol_zandy]
"HOST"="zandy"
"OPTIONS"="g=IER_group_z"
"PROTOCOL"="olsoctcp"
"SERVICE"="turbozz"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\net_online]
"HOST"="it-jtm"
"SERVICE"="turbo"
"PROTOCOL"="olsoctcp"
"OPTIONS"="x=net_online"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\ol_george]
"HOST"="george"
"SERVICE"="turbog"
"PROTOCOL"="olsoctcp"
"OPTIONS"="x=ol_george"
[HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SqlHosts\\ol_zandy]
"HOST"="zandy"
"SERVICE"="turboz"
"PROTOCOL"="olsoctcp"
"OPTIONS"="x=ol_zandy"
--------------C8A86857803A616BA6E48F61--