IBM Security i2

Expand all | Collapse all

IBM i2 iBase 9.0.2 - and MS SQL server

  • 1.  IBM i2 iBase 9.0.2 - and MS SQL server

    Posted Wed March 24, 2021 09:09 AM

    I can't find the documentation that shows if iBase 9 can run on MS SQL Express edition.
    Can it run? if yes, what are the drawback VS running it on a full MS SQL Essential or Standard edition?

    Thank you for your help... anyone.


    [Eric] [Niclaes]
    Sgt (Ret) CD2
    [IBM i2 specialist]
    [Necando Solutions Inc]
    [Montreal] [QC]
    [514-360-4000 Ext 625]
    Cell: 438-821-2402

  • 2.  RE: IBM i2 iBase 9.0.2 - and MS SQL server

    Posted Wed March 24, 2021 09:28 AM
    Hi Eric,

    I believe that technically we only support MS Essential, Standard, Datacenter etc, i.e. the ones which are approved for use in a production environment. We don't technically support Express or Developer edition.

    The reason being that certain features of the product will not work as well if you use SQL Server Express. For example anything that involves scheduling something with the SQL Server agent (which I do not believe is a part of Express) is harder to set up if you do not use one of the more fully featured SQL Server editions.

    That being said, you can find the listed system requirements for 9.0.2 of iBase here

    Using the IBM knowledge center is usually the fastest way to get to this information.

    You will see however that currently we seem to state only the version of SQL Server that is supported, and not the offering type, so I will ask internally for you to ask if we still support specific versions, i.e. if it is still Essentials upwards only, or if we now support all versions.

    Kind regards,
    – Dan Brace - IBM


  • 3.  RE: IBM i2 iBase 9.0.2 - and MS SQL server

    Posted Wed March 24, 2021 10:49 AM
    Hi Eric,

    I've now checked again with my colleagues, and can confirm that technically, we do support SQL Server at the versions listed at the link, including Express. It is only developer which isn't supported, because that's not supported for use in a production environment. (But again, SQL Server Express comes with the caveat that you will need to set up Windows Scheduled tasks for anything like Search 360 indexing or Alerting configurations which would otherwise rely on the SQL Server Agent in order to function).

    - Dan B


  • 4.  RE: IBM i2 iBase 9.0.2 - and MS SQL server

    Posted Thu March 25, 2021 03:37 AM
    Hi Eric,

    Not having any jobs available can be an issue. Something else that might be an issue when using SQL-Server Express are the size limitations.

    1GB maximum memory used by the database engine.
    10GB maximum database size.
    1MB maximum buffer cache.
    CPU the lesser of one (1) socket or four (4) cores

    Jan-Willem Lapoutre
    Senior software developer
    DataExpert b.v.