Search results

I never think so. 1. run slowly... I thought it maybe because of the machine is running as a file server. when user copy or write a big file , the machine maybe run slowly... 2.CPU INFO: 3.We have an enterprise license. 4.talked with you, I want do 2 things. 1: leave alone the machine to be db...

thank RHD and casper. 1.runs slowly, when openning a interface, or posting transaction, once in a while. 2.CPU:3G means 3.0GHz. 3.the machine is also a file server. I've doubt this, but can't make sure. 4.Progress help document gives the Multi-user Default (-B) size:(8 * users),"The users value...

recently, users told me ERP system runs slowly sometimes. Please give me some advice about DB startup parameters. DB size is about 12G, OS:WIN2003 MEM:2G CPU:3G. pf file: -L 80000 -TB 4 -TM 15 -inp 5000 -rand 2 -B 5000

eg. table_1 field_A field_B field_C 01 A 2 02 B 3 03 A 4 table_2 field_B field_D A 1 B 2 how can i get the first value from table_1 that field_C <= 3...

I think you can use diffrent procedure by checking last 3 characters. for example: case substring(filename,length(filename) - 3,3) : when "xls" then run procedure1. when "csv" then run procedure2.

Thanks and Happy New Year! :)

thank your guide

You are right, I realy need a DBA traning. But no traning plan in CHINA(Mainland). I'm studying by myself, So can't get full knowledge. what a pity! But luckly, I have a consultant. as his helping, I have Dump & Load successful in test DB. But I want know more about dump & load. So I put out...

answer your question: 1.just exercise, if ok, I'll do actual production environment 2.about 7G. 3.database runs about 2 years. So I think it need be processed. And I have some problems: 1.How to dump/load the data by binary? 2.How to dump/load the data by dd? I dumped the data by using...

I check tables' num, only 1513 whose num in 0 ~ 32768, but 1604 whose num < 32768. the tables whose num < 0, those name are begains "_", are hidden tables. these tables need not be dumped ? but i can dump them. for example, "_user", the user define table, control user' id & passwd, I think it...

I have found the error in the table .e file shows, and have repaired it. what's diffrence you said?

Thanks for your remind. one .e file exsits in my dump dir. it contains some char unknow, reassign it and then dump the table twice. It's no .e file now.

Thanks Casper & Tomhas! though I don't why use 1~32768. what're le 0 or ge 32768?

yes. exclude SYS tables like SYSCHARSTAT. the SYS tables needn't be dumped?

It shows 1646, but dump tables' num is 1604. why not equal ? when I dump .d file I select *.

"where not _hidden" means don't count hidden tables? I want count all tables include hidden. can i count all tables if not use "not _hidden"?

hello, everybody. I want dump a db's df file, then load it to a new db. But i don't know whether whole tables' df are dumped or loaded?

Thank you all the same!

Do you have excel handles with progress introductions? Can you mail to me?

thanks very much. It works