UDB Fixpack Problem with Replication 
Author Message
 UDB Fixpack Problem with Replication

We installed PTF U475003, VRMF 7.1.0.26 on Friday, and our 'apply' processes
have since been failing with:

SAT: TARGET_TABLE is ACD_PROFILE_310
CPMSGF: msg catalog is /u/db2inst1/sqllib/msg/en_US/asnapply.cat
MSGF: MsgNumber is 26.
The NLS msg is ASN1026E: The Apply program encountered an error while trying
to bind. SQLSTATE is , SQLCODE is -40..
SAT: SQLSTATE is
SAT: SQLERRM is applycs.lst?1
SAT: SQLCODE is -40

None of this makes any sense. We afterwards bound the files in sqllib/bnd
relating to apply to our databases, but with no change in results after
restarting the server.

Has anyone else had this experience?

Thank you for any assistance.

Tom



Sat, 23 Aug 2003 06:01:34 GMT
 UDB Fixpack Problem with Replication

SQLERRM is telling you about a bind complaint with file 1 in applycs.lst - which

is asnnf000.bnd. Is there a recent & valid asnnfXXX package in all of the
database servers involved in your replication set up? By recent, I mean
something since you applied the PTF. You can check for this info either in
syscat.packages or via control center under 'Application Objects'.

Quote:

> We installed PTF U475003, VRMF 7.1.0.26 on Friday, and our 'apply' processes
> have since been failing with:

> SAT: TARGET_TABLE is ACD_PROFILE_310
> CPMSGF: msg catalog is /u/db2inst1/sqllib/msg/en_US/asnapply.cat
> MSGF: MsgNumber is 26.
> The NLS msg is ASN1026E: The Apply program encountered an error while trying
> to bind. SQLSTATE is , SQLCODE is -40..
> SAT: SQLSTATE is
> SAT: SQLERRM is applycs.lst?1
> SAT: SQLCODE is -40

> None of this makes any sense. We afterwards bound the files in sqllib/bnd
> relating to apply to our databases, but with no change in results after
> restarting the server.

> Has anyone else had this experience?

> Thank you for any assistance.

> Tom



Tue, 26 Aug 2003 01:30:09 GMT
 UDB Fixpack Problem with Replication
Tom,

try running Apply with the TRCFLOW option and pipe it to a file.  I'll look the
trace over for you and see if anything jumps out at me.

Cheers,
Jim Stewart
IBM DataProp Tech Support

Quote:

> SAT: TARGET_TABLE is ACD_PROFILE_310
> CPMSGF: msg catalog is /u/db2inst1/sqllib/msg/en_US/asnapply.cat
> MSGF: MsgNumber is 26.
> The NLS msg is ASN1026E: The Apply program encountered an error while trying
> to bind. SQLSTATE is , SQLCODE is -40..
> SAT: SQLSTATE is
> SAT: SQLERRM is applycs.lst?1
> SAT: SQLCODE is -40



Sat, 30 Aug 2003 15:00:48 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. UDB/DB2 Fixpack 7 / JDBC : executeBatch problem

2. Cannot build programs for DB2 UDB V6.1 with FixPack FP10_IP22471.tar

3. Installing Fixpack 6 for 32 version on Db2 Udb EEE v7.1 on solaris

4. Is DB2 UDB 7.1 for W2k fixpack available?

5. Recommended Fixpack version for DB2 UDB V6.1 on W98 2ed

6. Fixpack 7 for DB2 UDB V6.1

7. recommended Fixpacks of UDB 6.1

8. How do you installing DB2 UDB fixpacks on Windows-98 clients from the Server

9. How to : Apply FixPack for UDB.

10. Replication & fixpack 2

11. problem with importing blobs in DB2 7.2 fixpack 7


 
Powered by phpBB® Forum Software