database without transactions.

georgipa · #1 (**permalink**) 10-22-09, 12:24

Hi Gurus,

I am defining a instance for create a database without transsactions, ¿it is necessary create dbspaces for physical and logical log?

Thank you for you help.

georgipa · #2 (**permalink**) 10-27-09, 13:59

Somebody can answer me for my question, please.

Thank you.

nitin_math · #3 (**permalink**) 10-28-09, 11:54

If there are no transactions, you can leave phylog and logical logs sitting in root dbspace, although it is not recommended. Out of curiosity, what is the purpose of the database if there are no transactions? Is is just for storing archived data?

regards,
Nitin

georgipa · #4 (**permalink**) 11-02-09, 08:22

Thank you nitin math,

This is a requiriment the customer, i not understand the reason not use transactions in this database.

greetings.

Internet Services

Web Development

Digital Marketing

Consumer Tech