DBINFO structure is not having place holder for the FixPack Level Information ? How to get it Programmatically?

DBINFO structure is not having place holder for the FixPack Level Information.

sqludf.h – in sqllib/include – used for external C procedures.
There is a C structure DBINFO holding various information related to Database.

** Database version/release. The field has the format pppvvrrm:
** ppp — identifies the product name
** vv — two digit rversion identifier such as ’03’
** rr — two digit release identifier such as ’01’
** m — one digit modification level identifier such as ‘0’
** OS Platform information. Please refer to Operating System
** “platform” definitions above for its definition.
SQL_STRUCTURE sqludf_dbinfo
unsigned short dbnamelen; /* database name length */
unsigned char dbname[SQLUDF_MAX_IDENT_LEN]; /* database name */
unsigned short authidlen; /* authorization ID length */
unsigned char authid[SQLUDF_MAX_IDENT_LEN]; /* appl authorization ID */
union db_cdpg codepg; /* database code page */
unsigned char ver_rel[SQLUDF_SH_IDENT_LEN];

Please find, it is providing only Version,Release,Modification levels.
There is no Fix Pack Level here?

How to get that information?

this is also in the following:
db2inst3@lubuntu-VM:~$ db2 -a connect to hup

Database Connection Information

Database server = DB2/LINUXX8664
SQL authorization ID = DB2INST3
Local database alias = HUP

SQLCA Information

sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 54
sqlerrmc: 91�1208�DB2INST3�HUP�QDB2/LINUXX8664�99�99�0�1208�1�1�
sqlerrp : **SQL11011**
sqlerrd : (1) 1 (2) 1 (3) 0
(4) 1 (5) 1 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000

You can also look for identifier:
SQL11011 – Which Means DB2 LUW – product,11 version,1 release,1 mudpack
No Place for Fix Pack?
How do I get it inside this structure?

I understand db2level provides the detailed information. I am looking for information through the C Data Structure.

harish pathangay


How to chage Data Cap8.1 property Field value

need to change Data Cap Property Field value from lets say 20 to 64. Where do you go in Data Studio to achieve this.

The reason we need to change the value is because some of the Exports are failing as the enter value exceeds the preset Datacap values
Please be detailed as we have experience with configuration of Data Cap.