I'm going to answer as many questions as I can, but I am not sure about sending data, as it's proprietary. I'm honestly unsure if even the field names, etc, might be considered private, and I'm waiting for confirmation/approval from my boss. Would field names or data be in the trace file? This all makes it sound much more exciting than it is, trust me. We're not tracking terrorists. There's just a few thousand data confidentiality hoops to jump through on one side and proprietary model development hoops on the other, and I take my responsibilities seriously when I work with data. I may be over-paranoid on this, but I'd rather be paranoid than breach a trust.
On Tue, Oct 11, 2011 at 2:08 AM, Thomas Mueller <[email protected]> wrote: > Hi, > The import seems to be still running, but the database is busy managing the > cache (specially removing old entries from the cache). I have a few > questions: > - What version of H2 do you use? 1.3.159 > - What is your database URL? jdbc:h2:file:K:\large files\variskDB; AUTO_SERVER=true > - Do you use any H2-specific system properties? I don't think so. > - Did you use any special settings? No. > - Is there a .trace.db file, and if yes could you post the contents? Would this contain any data elements? (Yes, there is a trace file, and I'll be happy to send it if it doesn't contain anything which could compromise the data.) > - How does the table definition and the data look like (could you post a few > example lines)? > - What statement(s) did you run exactly? The statement is generated dynamically from a data mapping performed by the user within a java application. Leaving out the bulk of the data until I get a confirm I can post it, the generated statement looks like this: CREATE TABLE tablename (ACTIVITYDT VARCHAR(55),LOANID VARCHAR(55),LOANNO VARCHAR(20),....ROW_ID IDENTITY )AS SELECT coalesce(ACTIVITYDT,''),coalesce(LOANID,''),coalesce(LOANNO,''),..., NULL from CSVREAD ('K:\Large Files\\inputfile.csv',NULL,NULL,char(9)) (It's much larger, of course, around 200-odd fields.) The "coalesce" is there because the user can specify a value to be used for each field if it is null. > - What operating system, file system, and virtual machine > (java -version) do you use? Window 7 64-bit, NTFS, 1.6.0.24 (64 bit) > - How did you start the Java process (java -Xmx... and so on)? java -Xms512m -Xmx4096m -cp VAriskH2c_v5.jar exec.FrontEndLauncher > - How big is the database (file sizes)? Currently, it is 241 GB. It was created when this process started and contained only some automatically-created utility tables we use as part of the program, none of which was of any meaningful size (either 0 or 1 rows, all very small) > - How much heap memory does the Java process have? According to task manager, it has 540 MB of RAM, and is using 10% of CPU. It's been at those levels for three days, roughly. I hope this helps. The process has been running since 10/7, and based on initial performance, I expected it to take ~20 hours. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
