populating array using awk

Shell Programming and Scripting
1

Hi.

I have a file with the following structer:

DB DISK LOCATION SIZE

PROD DATA_01 /dev/dm-23 10
PROD DATA_02 /dev/dm-24 10
PROD DATA_03 /dev/dm-25 10
DEV DATA_04 /dev/dm-26 10
DEV DATA_05 /dev/dm-6 10
FLASH DATA_20 /dev/dm-21 10
Total: 60

using kshell , I need to create an array for each type of distinct DB.
(The number of distinct DB is not constant and can be change.)
In this case i need to create 3 arrayies:
one for prod
one for dev
one for flash

each array should contain values from the first 3 columns.
The first 2 lines (headers) and the last line(Toatal ....) should be ignored.

I need your help with this problem.

Thanks Alot

2 
while read type data c junk
do
  case $data in
    DATA_*) eval "$type=( \"\${$type[@]}\" \"$type $data $c\" )" ;;
  esac
done < "$FILE"

##