Load and Insert Messages

You can use a database option and a server startup switch to control insert and load messages.

You may see messages during insert and load operations. The NOTIFY_MODULUS database option adjusts the default frequency of notification messages during loads, or omits these messages. The NOTIFY option in the LOAD command overrides the NOTIFY_MODULUS setting.

The IQMsgMaxSize server property and the -iqmsgsz server startup switch control message log wrapping and the size of the message log file.

Related concepts
Loads That Specify Input Data Format
Direct Loading of Data from Clients
Considerations for Partitioned Table Loads
Integrity Constraint Violation Messages