DS Load Method

bensonian · Post by **bensonian** » Mon Nov 24, 2008 9:47 am

Hi,

I was wondering to know when we use 'Write method' as Load, does it create 'Table level locks' on the table during the process of loading. If somebody could shed more light on this, it would be great.

Thanks

bcarlson · Post by **bcarlson** » Mon Nov 24, 2008 2:23 pm

I have not used the Oracle loader, but have used the Teradata and DB2 loads. They both lock the tables, not because of DataStage, but because of the underlying RDBMS utilities that are used (db2 load, Teradata FastLoad).

So what does this have to do with your Oracle situation? Figure out what Oracle utility DataStage uses to do the loads and look at the Oracle documentation to determine the rules for using the load utility. If the tool locks the table running from the command line or via PL/SQL, then I would assume that when DataStage invokes the load utility, it, too, will lock the table.

Brad.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 24, 2008 2:58 pm

Oracle uses SQL*LOAD (or, if you prefer, sqlldr), which does indeed set a table level lock (as, indeed, it must).