Hi, the batch output tables are generated in the schema described by the ExternalMKTData Db-admin-database instance. This instance setting is yours to set but it should be on the same DB instance as the pega data schema.
Thanks Nigel! I have setup a few schema under the same ExternalMKTData DB instance, so is it possible to have my customer records table in schemaA, but to direct those batch output tables generated into schemaB? Where can i go set this configuration?
Currently my customer records table is in schemaA, and the batchoutput tables are also generated under schemaA which is not ideal, since tablespace maintaince would be very tough.
Posted: 4 years ago
Posted: 21 Mar 2018 8:14 EDT
Nigel Peach (NigelPeach)
Director, DSM Service Engineering
Hi, slightly unsure about your point about 'further schema' under ExternalMKTData. This DB instance definition describes the default schema for that connection. The Batchoutput tables will be created in this default schema. The product also expects to find the customer data in this schema too, but as these are not dynamically created you could use synonyms as a way to host these ables in other schema ( if your DB supports synonyms ).
The only configuration available here is the specification of ExternalMKTData.