How to Set DAC System Properties
Supporting Tasks for DAC and Informatica PowerCenter
A-5
Drop and Create
Change Capture Views
Possible values are True and False.
When set to True (the default value), the DAC server drops and
creates change capture views every time it performs a change capture
process, including for both full and incremental loads.
Setting this property to True can create system catalog lock up for
DB2-UDB and DB2-390 databases. Therefore, by setting the property
to False, the DAC server will drop and create views selectively, using
the following rules:
In full mode:
During the change capture phase, views will be dropped and
created as full views.
During the change capture sync process, incremental views will
be generated.
In incremental mode:
If the view exists, it will not be dropped and created.
If the view does not exist, the incremental view will be created.
Dryrun
Possible values are True and False.
Indicates whether tasks are executed without invoking Informatica
workflows. The following processes are executed: change capture,
truncation of tables, drop and creation of indexes, and analyze
statements.
This option should be used for debugging purposes only and not
used in a production environment.
Generic Task
Concurrency LImit
Determines how many tasks with execution types other than
Informatica can be run concurrently. The value must be numerical.
To set this value, you should consider what the external tasks do. For
example, if the tasks open connections to a database, you should
consider how this would affect the preconfigured tasks.
HeartBeatInterval
Frequency (in seconds) the DAC server checks on the health of the
database connections. The value must be numerical. For example, a
value of 300 (the default value) indicates the system will perform
subsystem diagnostics and recovery procedures every 300 seconds.
InformaticaFileParamet
erLocation
Directory where the Informatica parameter file is stored.
Output Redirect
Indicates whether logging information and standard output and
errors are redirected to files in the log directory (when property is set
to True). The file containing standard output starts with out_ and
ends with the .log extension. The standard error messages are in the
file starting with err_ and ending with the .log extension.
If this property is set to False, the logging information is directed to
the machine's standard output and error files, which typically
defaults to the console from which the DAC server was launched if
the server was launched in a visible console mode. If the server is
launched as a Windows service, the logging information is directed to
the service log. If the server is launched with the command shell not
visible, all logging information is deleted
Repository DB Pool
Size
Indicates the maximum number of connections to the DAC repository
that the server will maintain.
Scheduler.Poll.Interval
Frequency (in seconds) the DAC server polls for changes in the
schedule configuration.
Property
Value Required