undocumented,but you can use this:
select name[1,18], sbcflag, hex(sbcflag), bitval(sbcflag, '0x00001') is_log, bitval(sbcflag, '0x08') keep_access from sysdbstab where sbcflag != 0
If 0, then it mens nolog and no_keepaccesstime
------------------------------
Vicente Salvador Cubedo
------------------------------
Original Message:
Sent: Wed June 03, 2020 06:38 PM
From: Art Kagel
Subject: Smart Blob Metadata Queries?
Thanks SangGyu. I had looked at that briefly but hadn't seen a correlation. I will play with that some more and see what I can figure out.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Original Message:
Sent: 6/3/2020 6:19:00 PM
From: SangGyu Jeong
Subject: RE: Smart Blob Metadata Queries?
Hi Art,
In the results of the onstat -g smb s command, the defaults value for sbspace seems to be related to the sbcflag column in the sysmaster:sysdbstab table.
After several changes to the default list with the onspaces -ch option, I can see that the sbcflag value changes.
However, the flag value corresponding to the default option is not documented, so it is questionable whether it can be defined accurately.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
Original Message:
Sent: Mon June 01, 2020 03:49 PM
From: Art Kagel
Subject: Smart Blob Metadata Queries?
Can anyone let me know how to determine the metadata defaults for an SBSpace in code? I know that I can get that from "onstat -g smb" but I want to be able to query the info using SQL or UDR API functions. Anyone?
------------------------------
Art Kagel
------------------------------
#Informix