Missing data in Query View - NSFDB2

HCL Domino Domino Forum
1

hi everyone, this is my situation:Domino 8.5 running on Windows 2003 SRV.

DB2 Enterprise 9.1

DB2 Access Server vrsion 7, build: Release 8.5

Database folder\test.nsf db2 enabled with DAV correctly updated and populated in DB2.

Database folder\get.nsf db2 enabled with Query View accessing the table of the DAV in first DB.

Opening the QueryView in the client i notice not all fields are showed;

so i checked inside the document there are all the fields filled properly.

I don’t understand why they’re not shown in the view…

have you guys ever found something similar ?

i’ll appreciate any helps!

Thanks

Marco

2

Subject: Re: Missing data in Query View - NSFDB2

What version of DB2 are you running? You said 9.1, but the fixpack version makes a difference too. 9.1.x?

If you issue the same query from the DB2 CLP, does it properly retrieve the data?

3

Subject: version…

Hello Patrick, thank for your reply.

I checked, the version is DB2/NT 9.1.0.356

thus I don’t have any fix pack…

could this is the problem?

Doing the same query in CLP i get the same situation, some fields are ok, others are just empty.

I can see the value of these fields opening the document properties in the client, though.

Thanks Marco

4

Subject: Re: version…

You should have DB2 9.1 fixpack 2 (9.1.2) for windows, or fixpack 2a for unix.

I’m not guaranteeing that upgrading will fix the problem, but you need to get to a supported environment first.

5

Subject: got it

Ok, i downloaded teh FixPack 7, which is the last one.Is that fine ?

I’ll install it and then i’ll let you know.

Thank you very much Patrick, i appreciated your help.

Marco

6

Subject: NO!!!

It must be fixpack 2 or 2a

the later fixpacks are NOT supported.

7

Subject: Notes Type

Hi Patrick,

I think i found the reason:

I downloaded SP 2 and installed it over the previous DB2.

The problem still there, some fields are missing.

Thus i checked the DAV and i noticed the missing fields are those which are defined as Number (in Access View Entry → Notes Type)…

I changed the Notes Type in Text and…

here you go: the value shows up!

Now the point is:

Is this a bug ?

Is there any solution but convert the data in the viewcolumn?

Thanks

Marco