Maximum Record length in DB2

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Hi All,

What is maximum record length in DB2? And What the main difference between SPUFI and QMF?

With Regards

Rajesh S

nuthan · Posted: Wed Oct 10, 2007 5:55 pm

A row has to fit on a page. So it depends on what page size is defined for
the tablespace that the table is utilizing (either explicitly or by
default). The largest page size is about 32K (with room needed for page and
row overhead). Certain kinds of large objects can be stored by DB2 that are
larger than 32K (which I assume you know about), but these not stored in a
normal tablespace.

nuthan · Posted: Wed Oct 10, 2007 5:57 pm

Differencr between Spufi and QMF is:
SPUFI :

1.you can execute more queries at a time.
2.you know the sqlcode after executing the query.

QMF:
1.you cannot execute more than one query.
2.you can't know the sqlcode of the query.

enrico-sorichetti · Posted: Wed Oct 10, 2007 7:58 pm

SPUFI

is a simple command environment to issue sql command and queries
useful for the development environment

QMF

is a an environment with sophisticated reporting features
there are large applications written in QMF
given some organizational assumptions
it is a tool that can be used directly by the end user to produce
highly customized reports