Problem with replication 
Author Message
 Problem with replication

Hi all,
We have db2 6.2 running on sun solaris and we try to set up
replication between two servers. As it may have been expected it
doesn't work and we are at a loss so any help would be highly
appreciated.
Firstly the output from the capture programs trace file. I had a look
and everything seems to work ok up until the data below:
******************************************************************************
 going to LOCK TABLE "DB2INST1"."CD20020219276380"
 SQLSTR = LOCK TABLE"DB2INST1"."CD20020219276380" IN EXCLUSIVE MODE
SQLCODE 0
 retry_limit 100
 retry_ct_op 0
 msgq_key mkey is 1224750758
 before calling msgq_init retcode is 0
 msgq_init msg_flag is 000003b6
 msgq_init msgget successful msgid is 2327
 trace_info called msg_type 16 retcode 0
REPORT_LOG
GET_NLS called w msg_type 16 retcode 0ASNLMSG msg_type in msg_parm =
16

 isuue msg rtn_name  ptr 000b8898
MSG_FILE msg_text ptr 00096560
 initialized msg_text to blanks  for 760
 MsgNumber  100 num_subs 0
 Did not get NLS message
GENERIC_MSG
 The generic msg is ASN0000S: INTERNAL ERROR OCCURRED FOR MESSAGE
NUMBER ASN0100I. ITS SUBSTITUTION FIELDS ARE . THE RETURN CODE IS 0.
.
 calling APPLWTO
 in APPLWTO

 before concat msg_text lmsg now 2002-02-20-16:22:49  

 after concat msg_text lmsg now 2002-02-20-16:22:49 ASN0000S: INTERNAL
ERROR OCCURRED FOR MESSAGE NUMBER ASN0100I. ITS SUBSTITUTION FIELDS
ARE . THE RETURN CODE IS 0.

 writing to log file rc was 136
 end of report_log  parmptr textptr 00096560
 trace_info from report_log message is ASN0000S: INTERNAL ERROR
OCCURRED FOR MESSAGE NUMBER ASN0100I. ITS SUBSTITUTION FIELDS ARE .
THE RETURN CODE IS 0.
numPreExistingUrids=0

 trace_info called msg_type 19 retcode 0
REPORT_LOG
GET_NLS called w msg_type 19 retcode 0ASNLMSG msg_type in msg_parm =
19

 isuue msg rtn_name  ptr 000b8898
 prune type is PRUNE
 start type is WARM STARTSEQ=0000000000000FE1408D
MSG_FILE msg_text ptr 00096560
 initialized msg_text to blanks  for 760
 MsgNumber  103 num_subs 4
 Did not get NLS message
GENERIC_MSG
 The generic msg is ASN0000S: INTERNAL ERROR OCCURRED FOR MESSAGE
NUMBER ASN0103I. ITS SUBSTITUTION FIELDS ARE A4GDBX,  WARM
STARTSEQ=0000000000000FE1408D,  ,  PRUNE. THE RETURN CODE IS 0.
.
 calling APPLWTO
 in APPLWTO

 before concat msg_text lmsg now 2002-02-20-16:22:49  

 after concat msg_text lmsg now 2002-02-20-16:22:49 ASN0000S: INTERNAL
ERROR OCCURRED FOR MESSAGE NUMBER ASN0103I. ITS SUBSTITUTION FIELDS
ARE A4GDBX,  WARM STARTSEQ=0000000000000FE1408D,  ,  PRUNE. THE RETURN
CODE IS 0.

 writing to log file rc was 190
 end of report_log  parmptr textptr 00096560
 trace_info from report_log message is ASN0000S: INTERNAL ERROR
OCCURRED FOR MESSAGE NUMBER ASN0103I. ITS SUBSTITUTION FIELDS ARE
A4GDBX,  WARM STARTSEQ=0000000000000FE1408D,  ,  PRUNE. THE RETURN
CODE IS 0.

 in rtn chk_cmd() time to do msgq_rcv
 calling msgq_rcv from  chk_cmd
 rc from msgrcv was -1
 errno was ENOMSG
 EXIT msgq_rcv  retcode 0 cmd_rcvd is FALSE
 EXIT chk_cmd      

 read_next first logsBytes = 0 logBytesWritten= 0
 compare logsBytes >= Written - 0 - 6first READ, call with Lsn + 1:
0000 0fe1 408d
 READ -  sqlurlog_api() startLSN: 0000 0fe1 408d
                       endLSN: ffff ffff ffff
 in main log_io thisCallApi is 000c8de8

 log_io CallApi buffer size = 204800

 The buffersize is 204800 bytes

 The buffersize is 204800 bytes

 CallApi pstartlsn = 000c92a6

 CallApi pstartlsn = 000c92a6
 value 0000 0fe1 408d
 setting first_read to false - can wait for commands now

 back from sqlurlog_api
 1 calling chk_cmd from log_io READ cmd_rcvd  0
 in rtn chk_cmd() time to do msgq_rcv
 calling msgq_rcv from  chk_cmd
 rc from msgrcv was -1
 errno was ENOMSG
 EXIT msgq_rcv  retcode 0 cmd_rcvd is FALSE
 EXIT chk_cmd    
*******************************************************************
Are these messages something we need to worry about or not?

Also the apply programs output came as :

******************************************************************
SAT: STATUS = -1
  SAT: LASTRUN = 2002-02-20-16.02.30.960662
  SAT: LASTSUCCESS = 2002-02-19-14.18.51.000000
  SAT: SYNCHPOINT is null
  SAT: SYNCHTIME is null
  SAT: SOURCE_ALIAS is A4GDBX  
  SAT: SOURCE_SERVER is A4GDBX
  SAT: SOURCE_OWNER is DB2INST1
  SAT: SOURCE_TABLE is IXN_SNSTATS
  SAT: TARGET_ALIAS is A4GDBX1  
  SAT: TARGET_SERVER is A4GDBX
  SAT: TARGET_OWNER is DB2INST1
  SAT: TARGET_TABLE is IXN_SNSTATS
    CPMSGF: environment variable LANG is not defined.
    CPMSGF: msg catalog is /sbclocal/db2inst1/sqllib/msg//asnapply.cat
    MSGF: MsgNumber is 3.
    MSGF: Did not get NLS message
    The generic msg is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE
NUMBER ASN1003E. ITS SUBSTITUTION FIELDS ARE A4GDBX1,  130301
    ,  42705,  -1013,  A4GDBX1,  SQLEDBCN. THE ERROR CODE IS 034907.9.
.
  SAT: SQLSTATE is 42705
  SAT: SQLERRM is A4GDBX1
  SAT: SQLCODE is -1013
  SAT: SQLERRP is SQLEDBCN
  SAT: APPERRM is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE NUMBER
ASN1003E. ITS SUBSTITUTION FIELDS ARE A4GDBX1,  130301,  42
  705,  -1013,  A4GDBX1,  SQLEDBCN. THE ERROR CODE IS 034907.9.

     CPMSGF: environment variable LANG is not defined.
     CPMSGF: msg catalog is
/sbclocal/db2inst1/sqllib/msg//asnapply.cat
     MSGF: MsgNumber is 48.
     MSGF: Did not get NLS message
     The generic msg is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE
NUMBER ASN1048E. ITS SUBSTITUTION FIELDS ARE APPLY_QUAL=APY_
     A4GDBX, SET_NAME=CPY_A4GDBX, SOURCE_SERVER=A4GDBX,
TARGET_SERVER=A4GDBX, TARGET_OWNER=DB2INST1, TARGET_TABLE=IXN_SNSTATS,
. T
     HE ERROR CODE IS 034907.9.
.
  SLP: Sleep for 6 seconds.
--- Process next subscription (8) ---
 CEXPC: connect to A4GDBXCT
 CPGCST: Control server timestamp is 2002-02-20-16.02.47.372835
  R1NES: No eligible named event subscription at this moment
  R1RTS: No eligible relative timer driven subscription at this moment
 TTOS: slpDay is 0; slpHour is 0, slpMin is 0, slpSec is 0, slpMSec is
0
 TTOS3: sleep_time = 300
 TTOS: error wait time (300 sec) in use.
 TTOS: delay_seconds = 300
 Delay_seconds = 300 seconds
  REST: Sleep time = 300 seconds.
    CPMSGF: environment variable LANG is not defined.
    CPMSGF: msg catalog is /sbclocal/db2inst1/sqllib/msg//asnapply.cat
    MSGF: MsgNumber is 44.
    MSGF: Did not get NLS message
    The generic msg is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE
NUMBER ASN1044I. ITS SUBSTITUTION FIELDS ARE 5,  0. THE ERROR
     CODE IS 034907.9.
.
   SLP: Sleep for 300 seconds.
******************************************************************************
As you can see it complains about the LANG variable, could that be the
reason?

As I said before any help would be greately appreciated.

TIA
Dimitris Magdalinos
UBS Warburg



Mon, 09 Aug 2004 00:53:54 GMT
 Problem with replication

In addition to checking connectivity for Apply, do export your environment
variables.  For Solaris:

export LD_LIBRARY_PATH=db2homedir /sqllib/lib:/usr/lib:/lib
export LANG=en_US
export NLSPATH=/usr/lib/locale/%L/%N:/db2homedir /sqllib/msg/en_US/%N

where db2homedir is wherever you installed DB2.

Michael

Quote:

> Well, unfortunately it's not just a msg problem (though you'll need to get
> that resolved to help with any future debugging).

> Right at the end, Apply returns error '48' aka asn1048 (if you look it up):

> ASN1048E The execution of a copy statement failed. See the Apply trail table
> for full details: "<text>"
> Explanation: A copy statement could not execute. In the message, "<text>"
> identifies the "<copy_server>", "<copy_owner, copy_table, stmt_number>",
> and "<cntl_server>".

> User Response: Check the APPERRM fields in the audit trail table to determine
> why the copy statement failed.

> And right before this, an sqlcode of -1013 is returned which is database or its
> alias cannot be found, i.e. A4GDBX1.

> Ensure that the machine where Apply is being run from can connect to all
> databases involved in your replication subscription.


> > Hi all,
> > We have db2 6.2 running on sun solaris and we try to set up
> > replication between two servers. As it may have been expected it
> > doesn't work and we are at a loss so any help would be highly
> > appreciated.
> > Firstly the output from the capture programs trace file. I had a look
> > and everything seems to work ok up until the data below:
> > ******************************************************************************
> >  going to LOCK TABLE "DB2INST1"."CD20020219276380"
> >  SQLSTR = LOCK TABLE"DB2INST1"."CD20020219276380" IN EXCLUSIVE MODE
> > SQLCODE 0
> >  retry_limit 100
> >  retry_ct_op 0
> >  msgq_key mkey is 1224750758
> >  before calling msgq_init retcode is 0
> >  msgq_init msg_flag is 000003b6
> >  msgq_init msgget successful msgid is 2327
> >  trace_info called msg_type 16 retcode 0
> > REPORT_LOG
> > GET_NLS called w msg_type 16 retcode 0ASNLMSG msg_type in msg_parm =
> > 16

> >  isuue msg rtn_name  ptr 000b8898
> > MSG_FILE msg_text ptr 00096560
> >  initialized msg_text to blanks  for 760
> >  MsgNumber  100 num_subs 0
> >  Did not get NLS message
> > GENERIC_MSG
> >  The generic msg is ASN0000S: INTERNAL ERROR OCCURRED FOR MESSAGE
> > NUMBER ASN0100I. ITS SUBSTITUTION FIELDS ARE . THE RETURN CODE IS 0.
> > .
> >  calling APPLWTO
> >  in APPLWTO

> >  before concat msg_text lmsg now 2002-02-20-16:22:49

> >  after concat msg_text lmsg now 2002-02-20-16:22:49 ASN0000S: INTERNAL
> > ERROR OCCURRED FOR MESSAGE NUMBER ASN0100I. ITS SUBSTITUTION FIELDS
> > ARE . THE RETURN CODE IS 0.

> >  writing to log file rc was 136
> >  end of report_log  parmptr textptr 00096560
> >  trace_info from report_log message is ASN0000S: INTERNAL ERROR
> > OCCURRED FOR MESSAGE NUMBER ASN0100I. ITS SUBSTITUTION FIELDS ARE .
> > THE RETURN CODE IS 0.
> > numPreExistingUrids=0

> >  trace_info called msg_type 19 retcode 0
> > REPORT_LOG
> > GET_NLS called w msg_type 19 retcode 0ASNLMSG msg_type in msg_parm =
> > 19

> >  isuue msg rtn_name  ptr 000b8898
> >  prune type is PRUNE
> >  start type is WARM STARTSEQ=0000000000000FE1408D
> > MSG_FILE msg_text ptr 00096560
> >  initialized msg_text to blanks  for 760
> >  MsgNumber  103 num_subs 4
> >  Did not get NLS message
> > GENERIC_MSG
> >  The generic msg is ASN0000S: INTERNAL ERROR OCCURRED FOR MESSAGE
> > NUMBER ASN0103I. ITS SUBSTITUTION FIELDS ARE A4GDBX,  WARM
> > STARTSEQ=0000000000000FE1408D,  ,  PRUNE. THE RETURN CODE IS 0.
> > .
> >  calling APPLWTO
> >  in APPLWTO

> >  before concat msg_text lmsg now 2002-02-20-16:22:49

> >  after concat msg_text lmsg now 2002-02-20-16:22:49 ASN0000S: INTERNAL
> > ERROR OCCURRED FOR MESSAGE NUMBER ASN0103I. ITS SUBSTITUTION FIELDS
> > ARE A4GDBX,  WARM STARTSEQ=0000000000000FE1408D,  ,  PRUNE. THE RETURN
> > CODE IS 0.

> >  writing to log file rc was 190
> >  end of report_log  parmptr textptr 00096560
> >  trace_info from report_log message is ASN0000S: INTERNAL ERROR
> > OCCURRED FOR MESSAGE NUMBER ASN0103I. ITS SUBSTITUTION FIELDS ARE
> > A4GDBX,  WARM STARTSEQ=0000000000000FE1408D,  ,  PRUNE. THE RETURN
> > CODE IS 0.

> >  in rtn chk_cmd() time to do msgq_rcv
> >  calling msgq_rcv from  chk_cmd
> >  rc from msgrcv was -1
> >  errno was ENOMSG
> >  EXIT msgq_rcv  retcode 0 cmd_rcvd is FALSE
> >  EXIT chk_cmd

> >  read_next first logsBytes = 0 logBytesWritten= 0
> >  compare logsBytes >= Written - 0 - 6first READ, call with Lsn + 1:
> > 0000 0fe1 408d
> >  READ -  sqlurlog_api() startLSN: 0000 0fe1 408d
> >                        endLSN: ffff ffff ffff
> >  in main log_io thisCallApi is 000c8de8

> >  log_io CallApi buffer size = 204800

> >  The buffersize is 204800 bytes

> >  The buffersize is 204800 bytes

> >  CallApi pstartlsn = 000c92a6

> >  CallApi pstartlsn = 000c92a6
> >  value 0000 0fe1 408d
> >  setting first_read to false - can wait for commands now

> >  back from sqlurlog_api
> >  1 calling chk_cmd from log_io READ cmd_rcvd  0
> >  in rtn chk_cmd() time to do msgq_rcv
> >  calling msgq_rcv from  chk_cmd
> >  rc from msgrcv was -1
> >  errno was ENOMSG
> >  EXIT msgq_rcv  retcode 0 cmd_rcvd is FALSE
> >  EXIT chk_cmd
> > *******************************************************************
> > Are these messages something we need to worry about or not?

> > Also the apply programs output came as :

> > ******************************************************************
> > SAT: STATUS = -1
> >   SAT: LASTRUN = 2002-02-20-16.02.30.960662
> >   SAT: LASTSUCCESS = 2002-02-19-14.18.51.000000
> >   SAT: SYNCHPOINT is null
> >   SAT: SYNCHTIME is null
> >   SAT: SOURCE_ALIAS is A4GDBX
> >   SAT: SOURCE_SERVER is A4GDBX
> >   SAT: SOURCE_OWNER is DB2INST1
> >   SAT: SOURCE_TABLE is IXN_SNSTATS
> >   SAT: TARGET_ALIAS is A4GDBX1
> >   SAT: TARGET_SERVER is A4GDBX
> >   SAT: TARGET_OWNER is DB2INST1
> >   SAT: TARGET_TABLE is IXN_SNSTATS
> >     CPMSGF: environment variable LANG is not defined.
> >     CPMSGF: msg catalog is /sbclocal/db2inst1/sqllib/msg//asnapply.cat
> >     MSGF: MsgNumber is 3.
> >     MSGF: Did not get NLS message
> >     The generic msg is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE
> > NUMBER ASN1003E. ITS SUBSTITUTION FIELDS ARE A4GDBX1,  130301
> >     ,  42705,  -1013,  A4GDBX1,  SQLEDBCN. THE ERROR CODE IS 034907.9.
> > .
> >   SAT: SQLSTATE is 42705
> >   SAT: SQLERRM is A4GDBX1
> >   SAT: SQLCODE is -1013
> >   SAT: SQLERRP is SQLEDBCN
> >   SAT: APPERRM is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE NUMBER
> > ASN1003E. ITS SUBSTITUTION FIELDS ARE A4GDBX1,  130301,  42
> >   705,  -1013,  A4GDBX1,  SQLEDBCN. THE ERROR CODE IS 034907.9.

> >      CPMSGF: environment variable LANG is not defined.
> >      CPMSGF: msg catalog is
> > /sbclocal/db2inst1/sqllib/msg//asnapply.cat
> >      MSGF: MsgNumber is 48.
> >      MSGF: Did not get NLS message
> >      The generic msg is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE
> > NUMBER ASN1048E. ITS SUBSTITUTION FIELDS ARE APPLY_QUAL=APY_
> >      A4GDBX, SET_NAME=CPY_A4GDBX, SOURCE_SERVER=A4GDBX,
> > TARGET_SERVER=A4GDBX, TARGET_OWNER=DB2INST1, TARGET_TABLE=IXN_SNSTATS,
> > . T
> >      HE ERROR CODE IS 034907.9.
> > .
> >   SLP: Sleep for 6 seconds.
> > --- Process next subscription (8) ---
> >  CEXPC: connect to A4GDBXCT
> >  CPGCST: Control server timestamp is 2002-02-20-16.02.47.372835
> >   R1NES: No eligible named event subscription at this moment
> >   R1RTS: No eligible relative timer driven subscription at this moment
> >  TTOS: slpDay is 0; slpHour is 0, slpMin is 0, slpSec is 0, slpMSec is
> > 0
> >  TTOS3: sleep_time = 300
> >  TTOS: error wait time (300 sec) in use.
> >  TTOS: delay_seconds = 300
> >  Delay_seconds = 300 seconds
> >   REST: Sleep time = 300 seconds.
> >     CPMSGF: environment variable LANG is not defined.
> >     CPMSGF: msg catalog is /sbclocal/db2inst1/sqllib/msg//asnapply.cat
> >     MSGF: MsgNumber is 44.
> >     MSGF: Did not get NLS message
> >     The generic msg is ASN1000S: INTERNAL ERROR OCCURRED FOR MESSAGE
> > NUMBER ASN1044I. ITS SUBSTITUTION FIELDS ARE 5,  0. THE ERROR
> >      CODE IS 034907.9.
> > .
> >    SLP: Sleep for 300 seconds.
> > ******************************************************************************
> > As you can see it complains about the LANG variable, could that be the
> > reason?

> > As I said before any help would be greately appreciated.

> > TIA
> > Dimitris Magdalinos
> > UBS Warburg



Wed, 11 Aug 2004 08:19:30 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problem with replication

2. SQLExec problem with Replication

3. Problems with Replication / Remote Logons

4. problem with replication

5. Problem configuring replication

6. urgent (problem in replication)

7. Problems with Replication

8. Hot Fix Caused Problem with Replication

9. Problems stopping replication - Please Help

10. problem with replication when changing sa password

11. int or uniqueidentifier and problem with REPLICATION


 
Powered by phpBB® Forum Software