HPUnload hanging on BLOB field.

Horacio Villa

HPUnload hanging on BLOB field.
Hi,

trying to Unload a table I get this message:

INZU425E AT POS(0,0) (02) CCSID CONVERSION NOT ALLOWED FOR LOB/XML COLUMN
WHEN SPANNED YES OPTION IS SPECIFIED.

I've used this:

GLOBAL LOCK YES QUIESCE YES
OPTIONS SPANNED YES;
UNLOAD TABLESPACE
DB2 NO
SELECT * FROM LIST(UNLDLIST)
OUTDDN REC
LOADDDN PUN
FORMAT VARIABLE ALL

The message error points to this as the failure cause:
2. CCSID CONVERSION NOT ALLOWED FOR
LOB/XML COLUMN: the unload command
requires a CCSID conversion for a LOB or XML
column

And then the relevant part User response:
User response: Consider removing the cause of the
failure or the SPANNED YES option.
1. do not allocate the OUTDDN file as an HFS file
----> not the case
2. remove the CCSID conversion request that affects
the LOB or XML columns

I couldn't find how to remove the CCSID conversion.
Any ideas?

Thanks,
Horacio Villa

Anguraj Rathinasamy

HPUnload hanging on BLOB field.
(in response to Horacio Villa)
Horacio, try with different FORMAT. Thanks

> On Jun 12, 2019, at 3:17 PM, Horacio Villa <[login to unmask email]> wrote:
>
> Hi,
>
> trying to Unload a table I get this message:
>
> INZU425E AT POS(0,0) (02) CCSID CONVERSION NOT ALLOWED FOR LOB/XML COLUMN
> WHEN SPANNED YES OPTION IS SPECIFIED.
>
> I've used this:
>
> GLOBAL LOCK YES QUIESCE YES
> OPTIONS SPANNED YES;
> UNLOAD TABLESPACE
> DB2 NO
> SELECT * FROM LIST(UNLDLIST)
> OUTDDN REC
> LOADDDN PUN
> FORMAT VARIABLE ALL
>
> The message error points to this as the failure cause:
> 2. CCSID CONVERSION NOT ALLOWED FOR
> LOB/XML COLUMN: the unload command
> requires a CCSID conversion for a LOB or XML
> column
>
> And then the relevant part User response:
> User response: Consider removing the cause of the
> failure or the SPANNED YES option.
> 1. do not allocate the OUTDDN file as an HFS file ----> not the case
> 2. remove the CCSID conversion request that affects
> the LOB or XML columns
>
> I couldn't find how to remove the CCSID conversion.
> Any ideas?
>
> Thanks,
> Horacio Villa
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Horacio Villa

HPUnload hanging on BLOB field.
(in response to Anguraj Rathinasamy)
Anguraj, thanks for your answer.

I think the only FORMAT option I can use is VARIABLE.

From Db2 High Performance Unload User's Guide:

SPANNED YES can only be used when the FORMAT option specifies one of the
following:
? VARIABLE
? USER provided the related LOAD statement can be generated
SPANNED YES cannot be used with DSNTIAUL, DELIMITED, INTERNAL and EXTERNAL
format.
when SPANNED YES is specified, the parameter TRIM YES does not apply for
LOB columns.