This video (no audio) shows users how to create, alter and drop tables. This is part of the Data Studio Tutorial series that show users how to accomplish their administrative tasks and development. Aqua Data Studio is now internationalized and you can configure ADS to use fonts which support the character set you want to display. Character set and internationalization We made enhancements to handle new subscription licensing features.
I have db2 express on mac, db2start works, and db2 connect works.However when I do anything on the database it gives me an error (eg. db2 list tables):
SQL0805N Package 'NULLID.SQLC2J23 0X4141414141564962' was not found.
SQLSTATE=51002
I try doing this:
And get these errors:
I also already did this (which seems to not help):
Did I miss something?
Is it not possible to connect from a 10.1 client to 10.5.x server?
1 Answer
The meesage says that you do not have the BIND right in the database.So ask your DBA to grant you the bind right and redo the bind command.The DBA has to issue
Alternatively the right could be granted to a group or role or the DBA has to run the bind under his authority.
MichaelTiefenbacherMichaelTiefenbacherDb2 Studio Download
Not the answer you're looking for? Browse other questions tagged macosdb2 or ask your own question.
IMPORTANT
This article is now OBSOLETE!
Please refer to this article instead.
A little over a week ago IBM released a new version of the DB2 beta for Mac OS X Leopard, following up on valuable feedback that we’d received in response to earlier versions. This version is important because it resolves a reported issue that was occurring when building drivers for languages like Ruby and PHP. Hence, I highly encourage you to download the latest DB2 for Mac now and save yourself the hassle of this issue.
The installation procedure is fairly straightforward, but I’ll spare you from having to read the “Installing and setting up DB2 for Mac OS X” PDF by providing some easy steps here.
Install DB2 on Mac
Step 1: Increase your system’s parameters by creating or editing /etc/sysctl.conf. Add the following parameters, save the file, and reboot your machine.
Step 2: Download and extract DB2 Express-C for Mac OS X. To extract the file you can run tar -xvzf db2exc_952beta_MAC_x86_64.tar.gz from a terminal. cd into the extracted folder by running cd exp.
Step 3: Run sudo ./db2setup and follow the wizard that appears. (Note that this step assumes that you have Java 1.6 installed.)
Data Studio For Mac
If you’d like specific instructions on installing Ruby and Rails, take a look at my previous post about this subject.
Give us your feedback
Try out DB2 on your Mac, experiment with it, and let us know what you think. Tell us what are your impressions, what you like, what you dislike, and what you’d want to see in future releases. Write me at cangiano{{AT}}ca.ibm.com, and I’ll be happy to hear from you. If this release is particularly important to you and you’re able to speak on behalf of your company, do feel free write as well, we are definitely looking for testimonials – and such letters could prove to be free exposure for your company as well. If you use DB2 on Mac in an interesting way, let us know about it. We truly value your opinions and are looking forward to hearing about how DB2 on Mac affects you.
Get more stuff like this
Subscribe to my mailing list to receive similar updates about programming.
Thank you for subscribing. Please check your email to confirm your subscription.
Visual Studio Db2
Something went wrong.
Data Types In Db2
I respect your privacy and take protecting it seriously. Feel free to review my privacy policy page for further details.