• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

Informix - Problem description

Problem IT31972 Status: Closed

THE COMMAND ONSPACES -CL AND THE TASK "CLEAN SBSPACE" WILL NOT CLEAN STRAY
SMART BLOBS UNTIL AFTER SERVER IS BOUNCED

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
It is possible that smart blobs can become stray, meaning that
they have reference counts of 0.

Normally, when this happens the server will automatically clean
up these sblobs from their sbspace, but there are sometimes
reasons that this does not occur.

When this happens, the command oncheck -pS will report sblobs
that have reference counts of 0 as below:

 Space Chunk Page = [3,3,5]  Object ID = 1800023459
    LO SW Version                  4
    LO Object Version              1
    Created by Txid                501
    Flags                          0x31  LO_LOG
LO_NOKEEP_LASTACCESS_TIME  LO_HIGH_INTEG
    Data Type                      0
    Extent Size                    0
    IO Size                        0
    Created                        Sun Sep 22 11:33:16 2019
    Last Time Modified             Sun Sep 22 11:33:16 2019
    Last Time Accessed             Sun Sep 22 11:34:06 2019
    Last Time Attributes Modified  Sun Sep 22 11:34:06 2019
    Ref Count                      0
    Create Flags                   0x31  LO_LOG
LO_NOKEEP_LASTACCESS_TIME  LO_HIGH_INTEG
    Status Flags                   0x0  LO_FROM_SERVER
    Size (Bytes)                   146364
    Size Limit                     -1
    Total Estimated Size           -1
    Deleting TxId                  -1
    LO Map Size                    200
    LO Map Last Row                -1
    LO Map Extents                 2
    LO Map User Pages              73

The command, onspaces -cl, or the task "clean sbspace" should
clean up these sblobs with ref counts of 0.

They do, however, if oncheck -pS reports these stray sblobs, the
server must first be bounced before the onspaces command or the
task will take effect.  If you run either before bouncing the
server, you will see a message in the online.log comparable to:

    02/24/20 22:45:26  Cleaning stray LOs in sbspace 'sblobsp'.

But a subsequent execution of oncheck -pS will confirm that
these stray sblobs still exist.

If you run the onspaces command or the task after the server is
bounced the command will work and clean the stray sblobs.

This down time to reclaim sbspace storage is inconvenient at
best for customers.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC5.                                                   *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.02.2020
10.12.2020
10.12.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.