List of Contributions

David Grove

Contact Details

My Content

1 to 20 of 50+ total
Posted By David Grove Sun October 29, 2023 11:58 PM
Found In Egroup: Informix
\ view thread
Good idea. I'll just have to create some chunks and drop some chunks (on the test platform).
Posted By David Grove Fri October 27, 2023 01:59 PM
Found In Egroup: Informix
\ view thread
IDS 12.10.FC14 Solaris 10 1/13 This is related to this prior thread which discusses sbspaces that contain objects with Ref Count = 0, or Ref Count = 1, but with zero tables in the database that actually reference the object. The work-around is simple and effective: bounce Informix, ...
Posted By David Grove Fri October 20, 2023 03:02 PM
Found In Egroup: Informix
\ view thread
The answer from Tech Support is that this is an Informix defect: IT37406 (idsdb00109227 ) : JAVA UDRS ARE INSERTING CLOBS IN DEFAULT SMART BLOB SPACE : Fixed in 14.10.xC7 Seems like we're "on a streak" with recent tech cases. First the APAR with the zombie sblobs. Now the (non-APAR) ...
Posted By David Grove Tue October 17, 2023 04:44 PM
Found In Egroup: Informix
\ view thread
Premature. I just inspected the online log, and observe that it reports that the (attempted) change to logging was already in effect. (I have turned logging off and on for that space so many times in recent days, that I had forgotten the current state, and just use the SQL API to turn logging ...
Posted By David Grove Tue October 17, 2023 04:38 PM
Found In Egroup: Informix
\ view thread
Ah, that resonates... you probably hit it. This server had been the primary in an RS pair. I had recently disabled logging on that space so that I could move a ton of sblobs without risking a long TX. In fact, I broke the mirror to avoid trucking a bunch o' bits across the WAN (primary and RSS are ...
Posted By David Grove Tue October 17, 2023 03:22 PM
Found In Egroup: Informix
\ view thread
Informix 12.10.FC14 Solaris 10 1/13 I have already opened a tech support case for this, but am posting here, in case anyone might recognize the problem and have a quicker answer. We have a table with a CLOB column. The table has a PUT clause defined, which specifies an sbspace in ...
Posted By David Grove Mon October 16, 2023 05:32 PM
Found In Egroup: Informix
\ view thread
The answer is that it's an APAR. https://www.ibm.com/support/pages/apar/IT31972 DG ------------------------------ David Grove ------------------------------
Posted By David Grove Fri October 13, 2023 12:21 PM
Found In Egroup: Informix
\ view thread
I opened a tech support case on this. DG ------------------------------ David Grove ------------------------------
Posted By David Grove Thu October 12, 2023 02:26 PM
Found In Egroup: Informix
\ view thread
IDS 12.10.FC14 Solaris 10 1/13 This may be similar to a previous issue I posted about, concerning a zombie sblob-- but in that case, the Ref Count = 1. Today, I'm interested in removing (garbage collecting, I would think) several sblobs in an sbspace. The reason for this is I want ...
Posted By David Grove Mon September 25, 2023 12:22 PM
Found In Egroup: Informix
\ view thread
Thank you, Art. I was basing my (erroneous) claim on this documentation: https://www.ibm.com/docs/en/informix-servers/12.10?topic=utility-onspaces-m-start-mirroring Obviously, I should have gone directly to the utility, itself. DG ------------------------------ David Grove ...
Posted By David Grove Fri September 22, 2023 07:42 PM
Found In Egroup: Informix
\ view thread
Informix 12.10.FC14 Solaris 10 1/13 How does one start (and stop) mirroring for an existing plogspace? I note that the documentation for 'onspaces -m' is careful to exclude 'plogspace' from the list of spaces upon which it operates. Thank you. DG ------------------------------ ...
Posted By David Grove Fri September 22, 2023 03:20 PM
Found In Egroup: Informix
\ view thread
Is there a way to edit the Reference Count for an sblob? Currently, in our production database, the Ref Count for the sblob (a mug shot) is 3. But, there are only two actual references to this photo in all of the tables in the database. Consequently, when I DROP the database (after importing it ...
Posted By David Grove Thu September 21, 2023 07:11 PM
Found In Egroup: Informix
\ view thread
Been a few weeks, but back to considering this issue, again. Force dropping the sbspace is a workable solution for my private (experimental) sandbox. I do experimenting here, before trying things on PRODUCTION. So, in my private instance, I have dropped all user databases, and (as expected) ...
Posted By David Grove Fri September 15, 2023 12:48 PM
Found In Egroup: Informix
\ view thread
In response to a recent effort (I have been trying, quite irregularly, for about 2 years), IBM sales contacted me. They thought I wanted a free trial of Informix. (They didn't realize we have been customers for more than 25 years [I have had that same account with the same email address for most of that ...
Posted By David Grove Wed September 13, 2023 01:49 PM
Found In Egroup: Informix
\ view thread
We try, periodically, to get Innovator-C, but can never accomplish it. Today, I tried again, and get the IBM bee just buzzing around in circles forever. If there is a way to actually get Innovator-C, we are interested. DG ------------------------------ David Grove ...
Posted By David Grove Tue September 12, 2023 12:28 PM
Found In Egroup: Informix
\ view thread
Thank you, again. I didn't have enough knowledge that your plan of attack would ever have occurred to me. Just for the sake of completeness, I will add one additional tidbit for a possible future reader... While working on the problem and trying to drop sysmaster and sysadmin, I bounced Informix ...
Posted By David Grove Mon September 11, 2023 07:15 PM
Found In Egroup: Informix
\ view thread
Just to bring some closure to this, for any future reader... (I have been out of the office for a few weeks, so this has been delayed.) BOTTOM LINE: IT ALL WORKED, EXACTLY AS ANDREAS SUGGESTED. Thank you, Andreas. DG ------------------------------ David Grove ------- ...
Posted By David Grove Thu August 17, 2023 02:22 PM
Found In Egroup: Informix
\ view thread
Thank you, David. So, are you saying that, essentially, 'buildsmi' really doesn't do all that is actually necessary to properly rebuild sysmaster? Regards, DG ------------------------------ David Grove ------------------------------
Posted By David Grove Thu August 17, 2023 02:09 PM
Found In Egroup: Informix
\ view thread
Solaris 10 1/13 IDS 12.10.FC14 In a recent tech support case, we needed to rebuild sysmaster. (Sysmaster had been dropped.) The engineer told me not to run 'buildsmi', but to bounce Informix. I did and, of course sysmaster was rebuilt. I should have asked, but didn't. Is there a ...
Posted By David Grove Wed August 16, 2023 06:23 PM
Found In Egroup: Informix
\ view thread
In a recent tech support case, when rebuilding sysmaster, the tech support engineer asked me not to run 'buildsmi', but, rather, to bounce the instance and let Informix rebuild it as part of initializing the instance. I do not know why this suggestion was made, but I did it. Does Informix do ...