Page 1 of 1
Datastage project location space
Posted: Wed Feb 19, 2014 8:03 am
by m_mani87
Hi,
If i create a project in datastage it is created in the path which is allocated for our projects (etl/IS/Projects). How much space is allocated to each of the project . Is there any limitaions for individual projects. If so where can i see and change according to my needs.
Posted: Wed Feb 19, 2014 8:27 am
by chulett
There is no space allocated per Project, it's just a folder. The space is controlled by size of the partition you've created it in and it serves all projects.
Posted: Wed Feb 19, 2014 11:10 pm
by PaulVL
If you are on a 32 bit version of the application, you may run into a ceiling on the quantity of jobs per project. We were topping off in the 4K range. Mileage will vary.
Posted: Thu Feb 20, 2014 12:48 am
by chulett
I think that may be more about the O/S you are running, from what I recall AIX imposes a limit on the number of sub-folders.
Posted: Thu Feb 20, 2014 9:49 am
by asorrell
I've found that once you start getting into the thousands of jobs it is time to think about splitting up the project. Otherwise maintenance becomes impossible as it starts taking hours to run a backup or syncproject on really large projects.
Those projects are also more likely to get stressed, have corruption, and are of course "critical" because they contain a lot of jobs. So announcing you need to take it down for several hours for backup / fixing is usually not popular.