How can I solve error message BMC50262E SPACE 'dbname.tsname' ALREADY IN USE BY A BMC UTILITY when I'm Loading several partitions of a Partitioned Tablespace with PART REPLACE keyword and I'm executing several concurrent jobs? |
Due to its architecture, BMC LoadPlus for Db2 product does not support loading the same object with or without PART n REPLACE syntax, when multiple jobs are executed simultaneously. This restriction occurs because LoadPlus cannot load the object when a BMC utility is currently using the table space or associated index spaces. Workaround BMC Software considers that it is more efficient to execute a single job and take advantage of the built-in Parallelism of BMC LoadPlus for Db2 product, rather than executing many individual jobs simultaneously, like what you can do with other utility products. This consideration arises from the fact that executing multiple simultaneous jobs may restrict access to other processes in the z/OS environment, as the JES Initiators are blocked until the jobs complete execution. Additionally, memory limitations may occur, as each address space requires its own allocated memory resources. Examples of syntax There are several alternative syntaxes that you can use to load Partitions in parallel for individual partitions or a range of partitions using a single BMC LoadPlus for Db2 job. These syntaxes take advantage of the unique BMC LoadPlus architecture, which is designed specifically to optimize performance using proprietary methods. Below are some examples of how the options can be specified for LOAD PART REPLACE. - LOAD PART x,y REPLACE <=== list of specific partitions Also, multiple INTO TABLE PART REPLACE statements can be specified for the same LOAD command as follows LOAD INTO TABLE A |