All
Accepted answers
wx fg · Feb 28, 2017 go to post

thanks for your answer!    But how to config? I find nothing about this in the backup/restore documentation.

Could you tell me ho to do this or the documentation link about this?  And can I use script  to do this config?

thanks!

wx fg · Apr 23, 2017 go to post

thanks very much!   

Now I can get the records by your answer, and I  can get the old/new value for each record  like this 

  w rs.Get("NewValue")

the output likes this,   aa  jj is the value of 2 columns in my table

my question is: How to split these old/new value  to each column?

wx fg · Apr 24, 2017 go to post

thanks! But rs.Get("NewValue") returns   string not list

I convert it to list like this:

 set columnValues= $EXTRACT(s,5,*) //remove the header
  set delimiter=$CHAR(4)_$CHAR(1)
  set columnCount= $LENGTH(columnValues, delimiter)
  SET list=$LISTFROMSTRING(columnValues,delimiter)

Is there other better method for convert to list?

wx fg · Jul 5, 2017 go to post

thanks!   for 2010 version,   ##class(%SQL.Statement).%ExecDirect()   for executing sql

wx fg · Jul 18, 2017 go to post

Is there some method for release the memory used for the rows that I have read because I read the records of resultset  one by one and forward only.   

wx fg · Jul 20, 2017 go to post

the query include longvarchar column. when the process memory (bbsize) is  16M by default, I can read about 100,000 rows and then prompt <store> error.  

After I change the process memory to 49M(the max size in version 2010.2), I can read about 300,000 row and then prompt <store> error.

So I need some method to release the memory for process

wx fg · Jul 20, 2017 go to post

not recursive. only so much rows, and include longvarchar column.

wx fg · Jul 20, 2017 go to post

Yes, I read rows one by one, the query include longvarchar column.  I can read about 100,000 rows when process memory size is 16m; and about 300,000 rows when process memory size is 49M

wx fg · Jul 20, 2017 go to post 
String sql="Select ID,Text from eprinstance.isegment";
  Statement st = dbconn.createStatement();

  java.sql.ResultSet rs = st.executeQuery(sql);
  
while(  rs.next()){

     String c=rs.getString("Text");
    System.out.println( c);
}

  st.close();
  rs.close();

  dbconn.close();

this is the demo code.   the "Text" column type is longvarchar

wx fg · Jul 21, 2017 go to post

I have pasted the demo code.  very simple,  I  get the same error every time when I run this code ( 16M-->100,000 rows   49M->300,000 Rows).

wx fg · Jul 21, 2017 go to post

I have tested this code ,but the result was same with my demo code.

wx fg · Jul 21, 2017 go to post

I think upgrade is impossible for me.   Is there a patch for this issue?

wx fg · Jul 21, 2017 go to post

great！ the new jdbc driver has resolved my issue!  Thanks!

wx fg · Jul 22, 2017 go to post

  I found this issue maybe resolved when I replace the jdbc driver with version 2017.1.  thanks

wx fg · Jul 23, 2017 go to post

there is no index on this column and I test for rebuilding all the index  of this table but can't resolve this issue.

wx fg · Nov 20, 2017 go to post

no locks in the view locks.   I backuped with 

BACKUP^^DBACK("","F","backup","tplusn_db.cbk","Y","%bakPath%\backup.log", "NOISY","Y","Y","",60, "F")

and restored with 

do EXTSELCT^DBREST(1,0,"plusn_db.cbk","list.txt",4,"","")

and do not appy Journal Files

wx fg · Jul 9, 2018 go to post

thanks.   But the error is   "set gid failure: Operation not permitted" when I execute "cctontrol stop cache" after I have modified the user's group to cacheusr.

wx fg · Jul 5, 2017 go to post

I found that there were some CRC check error for some blocks when I restored again,   I will backup  again and restore it .

Thanks!

wx fg · Jul 22, 2017 go to post

hi everyone

  thanks for your help.   I replace the jdbc driver with version 2017.1 and then this issue  looks like be resolved .

Thanks again!