create table mynames(id integer, name varchar(10))
@
create type tnames as char(10) array[5]
@
--
begin
  declare names tnames;
  declare i,cnt integer default 1;
  set names=array['AAAAA','BBBBB','CCCCC','DDDDD','EEEEE'];
  set cnt=cardinality(names);
  while i < (cnt+1) do
    insert into mynames values(i,names[i]);
    set i=i+1;
  end while;
  commit;
end
@
--
select * from mynames
@
drop table mynames
@
drop type tnames
@

2013-11-22-07.14.16.657188-360 I2622830A584       LEVEL: Error
PID     : 6750240              TID  : 15380       PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000         DB   : TMPDB
APPHDL  : 0-461                APPID: *LOCAL.DB2.131122131410
AUTHID  : DB2INST1
EDUID   : 15380                EDUNAME: db2taskp (TMPDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, probe:40
RETCODE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock detected"
          DIA8002C A deadlock has occurred, rolling back transaction.
DATA #1 : Hex integer, 4 bytes
0x00000001

2013-11-22-07.14.16.740874-360 I2623415A547       LEVEL: Error
PID     : 6750240              TID  : 15380       PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000         DB   : TMPDB
APPHDL  : 0-461                APPID: *LOCAL.DB2.131122131410
AUTHID  : DB2INST1
EDUID   : 15380                EDUNAME: db2taskp (TMPDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::deleteRows, probe:50
RETCODE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock detected"
          DIA8002C A deadlock has occurred, rolling back transaction.