function jazzdata and jazztemp files in /SQL**** directory and how to shrink
We do use ELM v 7.0.2 with DB2 v 11.1.4.5, In several subdirectories in /DB2/NODE0000/SQL**** we do find jazzdata and jazztemp files. Most of them are max 4GB, but there is one that uses 56GB diskspace. I have two questions.
1. What is the function of these files, obviously not created by DB2 but by ELM, so reorg has no effec on them.
2. How can I reduce the size of these files, as diskspace is not infinite.
regards
Fons
Accepted answer
2 other answers
These files will be entirely managed by DB2 in providing database functionality for ELM including DOORS Next. You must manage the available diskspace of your database server to provide whatever is needed - the last thing you want to happen is for DB2 to run out of disk.
Comments
Hi Ian,
a jazzdata file that uses 56GB diskspace, there should be possibilities to reduce this a bit. If these files are managed by DB2, I'd expect that there will be an utility to reorganize these files. As I said, diskspace is not infinite, I can't keep providing diskspace. There should be a way to maximize the size of these files.
regards
Fons
Ian's answer is correct. This is the file DB2 uses to store data in. As you continue using the ELM application you will continue to add data to it as you create new DOORS Next requirements, etc., so it will tend to continue to grow over time.
That said, there may be ways to have DB2 "reorganize" or "compact" the file from time to time. You'll need to consult DB2 documentation for how to do that. But again, as you add more artifacts in the ELM application, the data file will tend to grow over time after you do that.