Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread

 

By: Praveen Devarao
RE: rake db:migrate causes SYSIBM:CLI:-805 [ reply ]  
2009-03-17 18:44
Hi Johannes,

You will need to bind few packages on your client. Follow the below steps to bind the packages.

Through DB2 Control Center or DB2 Configuration Assistant, select and
connect to the database. Right click and select "Bind...". This will
bring up a list of utilities and files to bind. At a mininum, select
"CLI/ODBC" support and the file "ddcsmvs.lst" and db2schema.bnd and click on "Bind".

If doing through command prompt/terminal follow the below steps

$ cd sqllib/bnd
$ db2 connect to <database> user <username>
$ db2 bind @ddcsmvs.lst blocking all sqlerror continue grant public

http://www-01.ibm.com/support/docview.wss?uid=swg21215626

http://www.mydatabasesupport.com/forums/ibm-db2/122750-sqlstate-38553-a.html

Let me know how it goes.

Thanks

Praveen

By: Johannes Fahrenkrug
rake db:migrate causes SYSIBM:CLI:-805 [ reply ]  
2009-03-17 18:06
I'm running the ibm_db gem on a Solaris 10 box with Rails 2.3. When I try to connect to the db and make a simple select like the demo script over here http://antoniocangiano.com/2008/12/23/db2-on-mac-officially-released/ everything works fine.

BUT when I want to run
rake RAILS_ENV=production db:migrate

I get this:
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
Failed to retrieve tables metadata due to error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 SQLCODE=-443
/opt/gbcweb/rubyenterprise/lib/gems/gems/ibm_db-1.0.2/lib/active_record/connection_adapters/ibm_db_adapter.rb:1004:in `tables'
/opt/gbcweb/rubyenterprise/lib/gems/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:319:in `initialize_schema_migrations_table'
/opt/gbcweb/rubyenterprise/lib/gems/gems/activerecord-2.3.2/lib/active_record/migration.rb:436:in `initialize'
/opt/gbcweb/rubyenterprise/lib/gems/gems/activerecord-2.3.2/lib/active_record/migration.rb:400:in `new'
/opt/gbcweb/rubyenterprise/lib/gems/gems/activerecord-2.3.2/lib/active_record/migration.rb:400:in `up'
/opt/gbcweb/rubyenterprise/lib/gems/gems/activerecord-2.3.2/lib/active_record/migration.rb:383:in `migrate'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rails-2.3.2/lib/tasks/databases.rake:116
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:617:in `call'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:617:in `execute'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:612:in `each'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:612:in `execute'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:578:in `invoke_with_call_chain'
/opt/gbcweb/rubyenterprise/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:571:in `invoke_with_call_chain'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:564:in `invoke'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:2027:in `invoke_task'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:2005:in `each'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:2005:in `top_level'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:2044:in `standard_exception_handling'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:1999:in `top_level'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:1977:in `run'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:2044:in `standard_exception_handling'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/lib/rake.rb:1974:in `run'
/opt/gbcweb/rubyenterprise/lib/gems/gems/rake-0.8.4/bin/rake:31
/opt/gbcweb/rubyenterprise/lib/gems/bin/rake:19:in `load'
/opt/gbcweb/rubyenterprise/lib/gems/bin/rake:19


Any idea?

- Johannes