I am using Tableau Desktop 7 to connect to DB2 table which has 80 mil records. When i am connected live, i drag the "Number or records" as a sanity check, and it does not show anything. I did try several other fields like date etc and none of them produce anything. I know that some summary functions might not be supported by DB2 when connecting live.
So i made an extract - all records...but the extract is created only for like 3.5 mil records and it does not pull all 80 mil records. Is there a time out issue that i have to look in to either from the Desktop or the Database perspective?
You'd have to take a look in the logs files to see what is happening. There is no reason it shouldn't work. Support can help you out if you send them the logs.