I have Data Studio 22.214.171.124 installed under Red Hat Enterprise Linux 6.4. I am using the same connections and SQL content that I used in Data Studio 3.2.1. I am creating and editing SQL queries against a db2 database. Content Assist is not working for me, neither using the hot key Ctril-Space, the context menu Content Assist, or the Menu item Edit, Content Assist. Content Assist worked just fine in 3.2, and very occasionally, it will work in 126.96.36.199, but most of the time it does not. I have tried disconnecting and reconnecting the database on the configuration tab of the SQL editor I am working on, but that doesn't seem to resolve the issue.
A related issue is that the schema changes on me. The database connection has a default schema set for it. But the Current Schema shown on the Special registers tab defaults to my database connection userid. So when I run the SQL, it gives me an error that 'USERID.object' is an undefined name. I then change the schema on the Special Registers page, but it doesn't seem to always stick.
How do I resolve these two issues?