https://sourceforge.net/p/daffodilreplica/support-requests/2006-01-09T16:10:22ZRecent changes to support-requests2006-01-09T16:10:22Z2006-01-09T16:10:22ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net1695710a201f2e21574780441455793688c8a24c

<div class="markdown_content"><p>Try to replicate different schema on iSeries<br /> I got Replication on iSeries working!<br /> But it only works on tables with the same<br /> collection-names (on iseries called library names).<br /> </p> <p>Is there a possibilty to choose different collections<br /> respectivly libraries, if possible on the same iseries?<br /> </p> <p>My settings for publication:<br /> com.ibm.as400.access.AS400JDBCDriver<br /> jdbc:as400://ASTERIX/IBPKDB053;libraries=IBPKDB053;<br /> </p> <p>My settings for subscription:<br /> com.ibm.as400.access.AS400JDBCDriver<br /> jdbc:as400://IDEFIX/HK100C2;libraries=HK100C2;<br /> </p> <p>In spite of the fact that I want to use Collection<br /> HK100C2 in the subscription on IDEFIX for<br /> synchronisation, the collection with name IBPKDB053 (as<br /> used in the publication) is used for the IDEFIX.<br /> </p> <p>Also the struct_IBPKDB053_HK100C.xml contains only<br /> descriptions with collection name IBPKDB053.<br /> </p> <p>Is it possible to have different collection names?<br /> Is there an idea?<br /> </p> <p>Is this the problem? Replicator needs the same schema<br /> name for publication and subscription!?! So I have no<br /> chance to synchronise tables on one iseries, which<br /> belong to different schemas (respectively collections<br /> respectively libraries)?<br /> Or do I have to use a trick and detour using a firebird<br /> database, which does not support and need schema yet.<br /> </p> <p>For example:<br /> sync from iSeries1:IBPKDB053/R000700v to<br /> Firebird-db1/R000700v, then synsc from<br /> firebird-db1/r000700v back to another schema on the<br /> same iSeries iSeries1:IBPKDB061/R000700V!<br /> </p> <p>I hope you understand my problem!<br /> Do you know a better trick?<br /> </p> <p>The best solution would be to omit the schema name in<br /> the struc*.xml, cause for the iSeries jdbc driver you<br /> can give the<br /> default schema to the connection URL<br /> (jdbc:as400://IDEFIX/HK100C2).<br /> Is there an option for omitting schema name?<br /> </p> <p>Best regards and Ciao<br /> Helmut<br /> </p></div>