Configdb.lobs

Hello Ronnie Abrahiem,

My name is Yamini Naidu from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #33777
Case Title: Configdb.lobs

Please allow us some time to thoroughly assess the matter and provide you with a prompt response. Your patience is greatly appreciated.

If you have any additional information to share or need to provide further context, kindly reply to this email.

Sincerely,

Yamini Naidu

Yellowfin Technical Support Engineer

Hello Ronnie Abrahiem

The files you mentioned are related to the Yellowfin configuration database. Here's a brief overview of each:

1. Configdb.backup: This file is a backup of your configuration database. It can be used to restore the database to a previous state.
2. Configdb.data: This file contains the actual data of your configuration database. Metadata (reports, dashboards, users, etc.)
3. Configdb.lck: This is a lock file used to manage database access and ensure data integrity during operations.
4. Configdb.lobs: This file stores large objects (LOBs) such as binary data or large text fields.
5. Configdb.log: This is the transaction log file that records all changes made to the database. It is essential for recovery purposes.
6. Configdb.script: This file contains the SQL script used to recreate the database schema and data.

To manage the size of these files, consider the following:

• Regular Backups: Ensure regular backups to prevent data loss and manage the size of the backup files.
• Log Rotation: Implement log rotation for the Configdb.log file to prevent it from growing indefinitely. This can be configured in the database settings.
• Database Maintenance: Perform regular maintenance tasks such as archiving old data, optimizing the database, and cleaning up unnecessary records.
• Yellowfin Cleanup: Delete unused reports/dashboards, Remove old cached report data, Clean up audit/history tables, Remove unused users and roles.

Thank you,

Yamini Naidu

Yellowfin Technical Support

CONFIDENTIAL

Hi Yamini,

appreciate your support and sharing the information below. Please close the ticket. If we have more questions in the future, we will create a ticket.

Best Regards,

Ronnie Abrahiem

ロニー　アブラハム

IT Project Manager & Yellowfin BI Administrator

North American Information Technology Services

DENSO International America, Inc.

ronnie.abrahiem@na.denso.com

Tie: 5000-3460

Office: 248.750.3460

Fax: 248.213.2469

This communication and any attachments is meant only for the intended recipient(s) and may contain confidential and/or legally privileged information. If you are not an intended recipient, any review, use, dissemination, distribution or copying is strictly prohibited. Please notify us immediately by return e-mail and delete the message, including any duplicates, from your system. Thank you for your cooperation.

Hello Ronnie Abrahiem

Thanks for the confirmation.

I am glad to hear the issue was resolved. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

You will be receiving a Survey to evaluate our support, it would be very helpful for us if you could hit us with a SATISFIED on that Survey.

Regards,

Yamini Naidu

Yellowfin Technical Support