467,151 Members | 946 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

Loading Long Varchar for Bit Data


we use UDB 7 FP 12 on a Solaris 8 machine. I try to load data from an
IXF file to a table containing one column with the data type LONG
VARCHAR FOR BIT DATA. If I do so, it seems that the load-utility loops
and does nothing.

top shows one process with maximum cpu load. There are no I/O waits,
but kernel load is very high. Traces on HDD/SAN show no or only very
less I/O activity. There are about 4,000,000 rows in the IXF file and
loading about 60,000 rows lasts about 90 minutes (determined with
query load). Other loads run in acceptable time.

Are there any known bugs? Can someone help me?

Thanks & best regards

Nov 12 '05 #1
  • viewed: 1453

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Wayne Wengert | last post: by
1 post views Thread by Balaji Neelakantan Pooruli | last post: by
reply views Thread by JohnO | last post: by
7 posts views Thread by James o'konnor | last post: by
1 post views Thread by Steven Blair | last post: by
4 posts views Thread by spwpreston@gmail.com | last post: by
2 posts views Thread by John Smith | last post: by
7 posts views Thread by greywire@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.