Topic
  • 5 replies
  • Latest Post - ‏2016-06-07T13:45:28Z by rathvel
amccarl
amccarl
73 Posts

Pinned topic DB2 FAQ

‏2013-06-11T20:26:04Z |

Technical article 1298716 contains Frequently Asked Questions (FAQ) about DB2 for Linux UNIX and Windows versions 8.x, 9.1, 9.5 and 9.7.

  • amccarl
    amccarl
    73 Posts

    Re: DB2 FAQ

    ‏2013-06-14T14:29:01Z  
    Hello!  We've had a number of clients respond through feedback to our technical documents indicating that they have further questions or comments that require additional dialogue.  Unfortunately, our feedback is anonymous, so unless an email address or other contact information is included, we have no way to get back in touch with you.
     
    Within DB2 support, the management team asked if we could somehow link our documents to the forums so that we could invite more discussion - like this!   As a start, we chose a small set of  technical articles and "seeded" the forum with initial entries so that we could have a starting place for conversation.  The documents have now been updated with links to the forums as well.  
     
    Hopefully, we will make DB2 support better by providing more interaction around our technical information!
  • EricHuang
    EricHuang
    1 Post

    Re: DB2 FAQ

    ‏2013-10-28T06:01:28Z  

    The link to the answer of the original link are mismatched / broken. For example, The answer of Q16 (During instance creation DB2 creates several directories and files with permission that are open to all users. Can I manually change such file permission to not allow access to all users?) in Section A links to nowhere.

  • Slakshmi
    Slakshmi
    20 Posts

    Re: DB2 FAQ

    ‏2013-11-06T16:40:50Z  

    Thanks for notifying us. We are working on fixing the links. We will update you as soon as its fixed. Apologize for the inconvenience.

  • amccarl
    amccarl
    73 Posts

    Re: DB2 FAQ

    ‏2013-11-08T17:47:17Z  
    • EricHuang
    • ‏2013-10-28T06:01:28Z

    The link to the answer of the original link are mismatched / broken. For example, The answer of Q16 (During instance creation DB2 creates several directories and files with permission that are open to all users. Can I manually change such file permission to not allow access to all users?) in Section A links to nowhere.

    We think we've fixed all the links on that page.  If you find any other issues, please let us know.  Thanks again.

  • rathvel
    rathvel
    2 Posts

    Re: DB2 FAQ

    ‏2016-06-07T13:45:28Z  

    Dear All,

    We would like to know more about the LBAC column and row of DB2 9.7 LUW in WHERE clause which column does not have read access rights for the user.

    See below example : 

    Table1:
    Column1 - Protected and No read access for user1
    Column2 - Normal
    Column3 - Normal

    Table2:
    Column4 - Protected and No read access for user1
    Column5 - Normal
    Column6 - Normal

    SQL executed by USER 1:

    SELECT Column2, Column3, Column5, Column6 from Table1, Table2 WHERE Table2.Cloumn4 = Table1.Column1;

    Question : What will be the result after executing above query by USER1

    Thanks & Regards,
    Rathvel.