EXPORT command on DB2 UDB v6.1 on AIX and LOBS

Robert Ord

EXPORT command on DB2 UDB v6.1 on AIX and LOBS
I have a number of tables to export containing LOB data and EXPORT works
fine until I get the message;

SQL3040N Unable to use the lobpath/lobfile parameters as specified. Reason
code: "4".

"There are not enough lobfile names provided. For export, there are more
lobs than the number of lobfile names provided multiplied by
SQLU_MAX_SESSIONS. "

The limit seems to be 999 files per lobfile entry, so I added another
lobfile and managed to export a bit more.

This is fine if the number of lobs on the table is small, but what if there
are 10's of thousands of lobs.

Can I amend the SQLU_MAX_SESSIONS value, if so, how ? I can't find any
reference in the manuals to this parameter.


Regards

Rob





_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com



Nadir Doctor

FW: EXPORT command on DB2 UDB v6.1 on AIX and LOBS
(in response to Robert Ord)
I'm afraid that there isn't an easy way out for this - What I did in a
similar situation was as follows:

export to f:\pics_events_data\pics_events_data_subset01.txt of del lobs to
f:\pics_events_data\lobsdata\ lobfile 001, 002, 003, 004, 005, 006, 007,
008, 009, 010 modified by lobsinfile messages
f:\pics_events_data\pics_events_subset01_emsg.txt select * from
dba.pics_events where EVENT_NUM between 2001 and 11990 ;
export to f:\pics_events_data\pics_events_data_subset02.txt of del lobs to
f:\pics_events_data\lobsdata\ lobfile 011, 012, 013, 014, 015, 016, 017,
018, 019, 020 modified by lobsinfile messages
f:\pics_events_data\pics_events_subset02_emsg.txt select * from
dba.pics_events where EVENT_NUM between 11991 and 21980 ;
export to f:\pics_events_data\pics_events_data_subset03.txt of del lobs to
f:\pics_events_data\lobsdata\ lobfile 021, 022, 023, 024, 025, 026, 027,
028, 029, 030 modified by lobsinfile messages
f:\pics_events_data\pics_events_subset03_emsg.txt select * from
dba.pics_events where EVENT_NUM between 21981 and 31970 ;

... and so on.


-----Original Message-----
From: Robert Ord [mailto:[login to unmask email]
Sent: Wednesday, December 13, 2000 1:46 PM
To: [login to unmask email]
Subject: EXPORT command on DB2 UDB v6.1 on AIX and LOBS


I have a number of tables to export containing LOB data and EXPORT works
fine until I get the message;

SQL3040N Unable to use the lobpath/lobfile parameters as specified. Reason
code: "4".

"There are not enough lobfile names provided. For export, there are more
lobs than the number of lobfile names provided multiplied by
SQLU_MAX_SESSIONS. "

The limit seems to be 999 files per lobfile entry, so I added another
lobfile and managed to export a bit more.

This is fine if the number of lobs on the table is small, but what if there
are 10's of thousands of lobs.

Can I amend the SQLU_MAX_SESSIONS value, if so, how ? I can't find any
reference in the manuals to this parameter.


Regards

Rob





____________________________________________________________________________
_________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com