DB2 Troubleshooting

 Failure Creating a Database in DB2

Error: SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: ""
Resolution: 

• Add the domain user ID to the local group DB2ADMNS.

• Open the DB2 command window - Administrator and run the following commands from the prompt:

            db2 update dbm cfg using sysadm_group DB2ADMNS
            db2stop                                        
            db2start

•  Use the runas command to run as db2admin user so as to be able to create database

• Run the following command to set the DB2 command line (DB2CLP) variable

            db2cmd -i -w db2clpsetcp

            db2set DB2_GRP_LOOKUP=LOCAL      

            runas /noprofile /user:db2admin cmd

            Enter the password for db2admin: <Enter the password>

MQSI Commands

Create a note

  mqsicreatebroker INODE -i [user] -a [passord] -q QMGR 

 Delete a node

  mqsideletebroker INODE

HTML

 Add Patreon link

<a  href="[add url of your Patreon page]">

<button class="patreon-button">Become a patron!</button></a>

Xpath Code Snippets

 Convert UTC date time to local date time

fn:adjust-dateTime-to-timezone(xs:dateTime($value), xs:dayTimeDuration('PT2H'))

PT2H means UTC+2