Excessive logging in version 12.10

Hey all, We recently upgraded from 11.70FC7 to 12.10FC13. During the upgrade I created new log space with logs that were twice as big as they were in 11.70. Despite that change, the amount of logging has increased on the server. Does anyone know of a feature in 12.10 that might be creating the additional logs? -- Best Wishes, Kate Tomchik She/Her Principal Systems Engineer, Database Solutions The Home Depot Cell: 678-427-4914 (Text preferred) For non-urgent requests create a TICKET for the database engineers: https://servicecatalog.apps.homedepot.com/home/catalog/Databases/databasesupport Choose experience: IT-09034-Database Solutions Operations The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment. INTERNAL USE

HI Kate, I have not seen this, the only APAR I know with excessive logging iis for Version 14: https://www.ibm.com/support/pages/apar/IT39156 IT39156: HEAVY SYSPROCPLAN LOGICAL LOG ACTIVITY AFTER UPDATING STATS FOR TABLES IN A PROCEDURE OR FUNCTION If you dump the log with onlog which table/index does the partnum map to? Regards, David. ------------------------------ David WilliamsDavid Williams ------------------------------

As the person who raised the case that led to this defect being logged you would need a busy system with a high core count and a lot of active threads calling stored procedures to see this defect. ------------------------------ Benjamin Thompson ------------------------------

The way to get started on this problem is to use the onlog utility to write a logical log to a file then look to see which tables or indices are being written to. It may be possible to spot some patterns. The partn utility from the IIUG software repository is useful for easily converting the part number to friendly object names. Using onlog and understanding the fields and which column is the part number are documented here: https://www.ibm.com/docs/en/informix-servers/12.10?topic=utilities-onlog-utility https://www.ibm.com/docs/en/informix-servers/12.10?topic=structure-logical-log-record-types-additional-columns Ben. ------------------------------ Benjamin Thompson ------------------------------