IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

Support of btrfs on Db2 11.1.3.3 is required

Daimler needs support of btrfs on Db2 11.1 on SLES 12 SP3.
result of IBM PMR (Case TS000138704):
“Although the DB2 documentation only lists recommended file systems, support for unlisted file system might be limited and there is no guarantee that DB2 will work with it.
Whether it is not supported or not tested would mean that it can generate an error on your machine in certain phases.”

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/r0056470.html
BTRFS is not listed, therefore it is not recommended.
Technote swg21978698 covers installation of Db2 on BTRFS (in our blueprint: /opt/IBM/db2), which has already known issues.
http://www-01.ibm.com/support/docview.wss?uid=swg21978698

Even we at Daimler are currently discussing root filesystem (“/”) and we basically do not use the root filesystem for DB2 (no installion, no data container), root fs is still used:
- in installation which uses /tmp => solution: we could define /tmp as separate filesystem
- by any kernel call (forking process , performing I/O)
Setup layout at Daimler on SLES:
/opt/IBM/db2 xfs Installation directory
/srv/db2/home xfs Instance home directory
/srv/db2/var xfs dumpg directory
/srv/db2/data1 xfs Data$Index tablespace container directory
/srv/db2/temp1 xfs Temp tablespace container directory
/srv/db2/evmon xfs Event monitoring directory
/srv/db2/onredop xfs Logpath
/srv/db2/onredom xfs Mirrorlogpath
/srv/db2/offredo xfs Archive log path for emergency
/dbshare xfs Application related data
/free_SOD xfs Free Storage to sue on demand
/ ??? OS root filesystem
Default Filesystem of "/" (root fs ) is btrfs, but it is not supported by Db2!
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 3 2019
  • Delivered
Idea Priority Urgent
Customer Name Daimler AG
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions