Save 
Join IIUG
 for   
 

RSS Feed: IDS Forum: IDS

More IIUG RSS Feeds

The IDS Forum is a discussion forum to communicate about all aspects of the Informix Dynamic Server (IDS) Engine


URL: http://www.iiug.org/rss/ids.rss

Below is the latest content available from this feed:

Re: PC_POOLSIZE?
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Thu, 22 Aug 2019 15:06:31 EDT
Original post:



Oops. Informix won't let me do this.



That is, one cannot use 'onmode -wm' or 'onmode -wf' to change the value of

PC_HASHSIZE.



(At least the documentation would seem not to offer this as an option-- see

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_0131.htm

)



I'll have to wait for our next maintenance period, as this is a production

instance.



DG



Response:



Yeah, going with your previous post as well, the server doesn't allow the

value of PC_HASHSIZE to be changed on the fly, as it's used as part of hashing

into the cache. If you allowed that to change, you would potentially be moving

the location of lots (?) of items in the cache. So the server would probably

have to just rebuild the entire cache, which I'm guessing the complexities of

doing that while online was not worth the risk so it's not allowed.



Jacques Renaut

HCL Informix Advanced Support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41796]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: PC_POOLSIZE?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Thu, 22 Aug 2019 14:42:44 EDT
Oops. Informix won't let me do this.



That is, one cannot use 'onmode -wm' or 'onmode -wf' to change the value of

PC_HASHSIZE.



(At least the documentation would seem not to offer this as an option-- see

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_0131.htm

)



I'll have to wait for our next maintenance period, as this is a production

instance.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41795]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: PC_POOLSIZE?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Thu, 22 Aug 2019 14:25:41 EDT
Thank you, Jacques, for your thorough and helpful response.



First, I checked, and PC_POOLSIZE is defined only once in ONCONFIG.



Second, I have not changed PC_POOLSIZE via 'onmode -wm'.



Third, 'onstat -g cfg full' shows default: 126; onconfig: 127; and current:

566.



I conclude that Informix has made adjustments automatically. It would be

helpful if that were in the documentation. (Maybe it is, but I just didn't see

it.)



But, I would also offer the thought that, if Informix automatically adjusts

the PC_POOLSIZE, maybe it should also adjust the PC_HASHSIZE. In this

instance, although PC_POOLSIZE has increased to 566, PC_HASHSIZE remains at

31.



There is a very high disparity in the "hits" column-- from 2 to about

100,000,000.



I think I should manually increase PC_HASHSIZE. I'll try 127, and see if that

that "spreads out" the distribution a little more.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41794]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: PC_POOLSIZE?
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Wed, 21 Aug 2019 21:15:25 EDT
Original post:



IDS 12.10.FC12

Solaris 10 1/13



How does PC_POOLSIZE get changed?



In our ONCONFIG file, the PC_POOLSIZE parameter is entered as:



PC_POOLSIZE 127



The first few lines of 'onstat -g prc' are as follows:



informix@ifmx-prod-anc>onstat -g prc|more

IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 22 days

08:15:40 -- 19693568 Kbytes

UDR Cache:



Number of lists : 31



PC_POOLSIZE : 566



How did PC_POOLSIZE get to be 566?



I do have AUTO_TUNE set to 1, but I don't seem to see anything in the

documentation for "AUTO_TUNE" that would lead me to believe that PC_POOLSIZE

is one of the parameters that AUTO_TUNE adjusts dynmaically. Maybe I am just

not understanding the documentation.



I welcome an explanation.



Thank you.



DG



Response:



So a couple thoughts. First is would there be any chance you have PC_POOLSIZE

in your onconfig more then 1 time? If that is the case, it would take the last

entry it found for the value. Second, it does appear that you could use onmode

-wm to modify this parameter dynamically as long as you are increasing the

size. You should be able to run onstat -g cfg full (will probably want to

redirect the value to a file), then search the file for PC_POOLSIZE and it

will show default, current, and onconfig values. So I would guess if the first

idea isn't happening, then onconfig setting will be 127 and current I believe

would show 566. That could happen via onmode -wm (so it was ran and only

changed memory, not file). Lastly, a quick look at code does seem to show that

for certain conditions while processing a cache misses, the server would

increase the size of the cache by 10% of it's current size (whether this

happens or does not appear to be controlled by AUTO_TUNE, it looks like the

server has been coded to just increase the size to reduce certain types of

cache misses...so not every cache miss would trigger the increase in size).

I'm not 100% certain of this because I believe the server has 2 different

implementations of caches and a quick look it wasn't easy to tell if the

procedure cache is implemented in this manner or not. I would infer that it is

using this method of caching if idea's 1 and 2 are not true, as then that

would explain the increase in the cache size. A quick look at this code also

didn't seem to show a way to limit growth in this case. Also, in this

automatic growth case, the onstat -g cfg full would also show the current

value as 566, so from just that output it wouldn't be possible to distinguish

option 2 from option 3, as option 3 also ends up setting the "current" size

displayed in the onstat -g cfg full.



Jacques Renaut

HCL Informix Advanced Support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41793]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: "hits" reported by 'onstat -g prc'?
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Wed, 21 Aug 2019 20:45:12 EDT
Original post:



IDS 12.10.FC12

Solaris 10 1/13



I run 'onstat -g prc' and examine the output for a particular SPL. I observe a

number (12) reported under the "hits" column.



I believe this indicates that the particular SPL I am interested was accessed

from the cache 12 times.



Since when, though? Since Informix was last restarted? I don't see that info

in the documentation.



In other words, onstat -g prc tells me how many times a certain SPL was

executed since the server was last restarted?



Or maybe not. Maybe SPLs can leave the cache (being replaced by one used more

frequently), and then maybe come back in. In that case, the "hits" would be

reset, wouldn't it?



Just wondering in more detail how 'onstat -g prc' works.



Thank you.



DG



Response:



It would be since the item was brought into cache, and yes it would be

possible for items to be removed from the cache is the cache isn't big enough

and it hits the cleaning threshold for a particular list.



Jacques Renaut

HCL Informix Advanced Support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41792]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

"hits" reported by 'onstat -g prc'?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Wed, 21 Aug 2019 20:14:07 EDT
IDS 12.10.FC12

Solaris 10 1/13



I run 'onstat -g prc' and examine the output for a particular SPL. I observe a

number (12) reported under the "hits" column.



I believe this indicates that the particular SPL I am interested was accessed

from the cache 12 times.



Since when, though? Since Informix was last restarted? I don't see that info

in the documentation.



In other words, onstat -g prc tells me how many times a certain SPL was

executed since the server was last restarted?



Or maybe not. Maybe SPLs can leave the cache (being replaced by one used more

frequently), and then maybe come back in. In that case, the "hits" would be

reset, wouldn't it?



Just wondering in more detail how 'onstat -g prc' works.



Thank you.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41791]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

PC_POOLSIZE?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Wed, 21 Aug 2019 19:47:18 EDT
IDS 12.10.FC12

Solaris 10 1/13



How does PC_POOLSIZE get changed?



In our ONCONFIG file, the PC_POOLSIZE parameter is entered as:



PC_POOLSIZE 127



The first few lines of 'onstat -g prc' are as follows:



informix@ifmx-prod-anc>onstat -g prc|more

IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 22 days

08:15:40 -- 19693568 Kbytes

UDR Cache:



Number of lists : 31



PC_POOLSIZE : 566



How did PC_POOLSIZE get to be 566?



I do have AUTO_TUNE set to 1, but I don't seem to see anything in the

documentation for "AUTO_TUNE" that would lead me to believe that PC_POOLSIZE

is one of the parameters that AUTO_TUNE adjusts dynmaically. Maybe I am just

not understanding the documentation.



I welcome an explanation.



Thank you.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41790]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Monitoring SPL Executions?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Wed, 21 Aug 2019 14:53:44 EDT
"I simply pull from "onstat -g prc" ... my watcher runs constantly and picks

up any and all SPLs (seen before or new), tallying them so I always have a

datetime|procname|executions_at_that_time record. This actually came in handy

recently to find most used SPLs - never thought it would.



Thanks -

Mark Scranton"



Mark,



Might you comment a bit further on your watcher?



When you say your watcher runs constantly, and you pull from 'onstat -g prc',

what exactly do you mean? Do you execute 'onstat -g prc' every few seconds,

and then parse out (and accumulate) the information you want to monitor?



Thank you.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41789]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

BTS-Query on RSS Secondary
Posted by: ruediger.papke@t-online.de (RUEDIGER PAPKE) - Wed, 21 Aug 2019 07:18:02 EDT
informix:IBM Informix Dynamic Server Version 12.10.FC12

OS:SUSE Linux Enterprise Server 12 (x86_64) VERSION = 1 PATCHLEVEL = 3



Problems doing a BTS-Query on RSS-Secondary after INSERT/DELETE on Primary.



I have created a Sbspace(-Df "LOGGING=ON") and also a temporary Sbspace.



BTS-Index on lvarchar column.



RSS-Replication works fine.



When a row is insertet or deletet on Primary, a BTS-Query works only on

Primary.

The same Query on RSS results in ERROR:

echo 'select * from errtable where bts_contains (errcol,"trigger")order by

nr;' | dbaccess db1

Database selected.



(BTSA1) - bts clucene error: IO error: FSE IO cannot open file

/informix/err_bts/3146080/segments



Error in line 1

Near character position 71

Database closed.



After restart of RSS-Server the BTS-Query works and delivers the same result

as on Primary.



What's wrong? Any Idea?

Thanx

Ruediger









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41788]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: memory monitor
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Tue, 20 Aug 2019 13:07:01 EDT
Original post:



HI,



I use informix version 12.10, How to monitor below memory through SMI?



dictionary cache;



table statistics cache;



.......



thanks for your time.



Lu chuan



Response:



Well first off, when you say "table statistics cache" I'm assuming you mean

the cache the server uses for data distributions (as reported by the onstat -g

cac dst command). A quick command to get the information about the "dictpool"

and the "dstpool" (that should be the pool used for the shared data dictionary

and the distribution dictionary) would be this:



select * from syspools

where po_name = "dictpool" or po_name = "dstpool";



example output from my tiny test instance:



po_id 32

po_address 1176387648

po_name dstpool

po_class 2

po_freeamt 1640

po_usedamt 6552



po_id 30

po_address 1176350784

po_name dictpool

po_class 2

po_freeamt 1168

po_usedamt 199536



2 row(s) retrieved.



I made sure I had run 1 query on a table with a single column that I had built

distributions on (so onstat -g cac dst does have 1 entry in it)...so very

small portions of onstat -g cac dst and onstat -g dic output as well:



onstat -g cac dst



....



Total number of distribution entries : 1



onstat -g dic

....

Total number of dictionary entries: 22



From the query you would be interested in the po_freeamt and po_usedamt which

is the free memory in the pool and the used memory in each of the respective

pools.



Jacques Renaut

HCL Informix Advanced Support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41787]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

memory monitor
Posted by: luchuan114@sina.com (CHUAN LU) - Tue, 20 Aug 2019 09:43:23 EDT
HI,



I use informix version 12.10, How to monitor below memory through SMI?



dictionary cache;



table statistics cache;



.......



thanks for your time.



Lu chuan









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41786]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Spaces and Spindles: Thought Experiment
Posted by: david.grove@alaska.gov (DAVID GROVE) - Mon, 19 Aug 2019 13:12:01 EDT
Also, please assume that the controller has sufficient bandwidth to accomodate

I/O to three spindles, simultaneously.



I'm not certain of this (since the drives are SSDs), but, consider the

proposition as if the controller were not a bottle neck.



FYI, the configuration is as follows:



Two controllers. Three SSDs on each controller. The first drive on each

controller is a mirrored pair. Same with second and third. So, three mirrored

pairs, each of those pairs having one drive on one controller, and the other

drive on the other controller.



I plan to do some experiments, but, ultimately, am seeking to determine

whether there is benefit to placing individual dbspaces and sbspaces on

particular drives, or whether one might better obtain even distribution of

disk I/O by striping all three mirrored pairs together, and putting all

dbspaces and sbspaces on that single stripe of mirrored pairs (RAID 1 "on top"

of RAID 0).



Figured maybe some knowledgeable opinion might get me a head start.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41785]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Spaces and Spindles: Thought Experiment
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 16 Aug 2019 14:25:08 EDT
For extra credit, consider having two dbspaces for logical logs (odd and

even).



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41784]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Spaces and Spindles: Thought Experiment
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 16 Aug 2019 14:21:43 EDT
IDS 12.10.FC12

Solaris 10 1/13



Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows:

1) dbspace for the database catalog and data tables;

2) dbspace for indexes (16K pages);

3) sbspace for sblobs (photos-- relatively infrequently accessed);

4) root dbspace (with physical log);

5) dbspace for logical log;

6) temp dbspace.



If you were constrained to have only three "spindles", A, B, & C (each

"spindle" actually a mirrored pair of SSDs), how would you assign spaces to

spindles?



Thank you.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41783]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Load from external table issues
Posted by: luis-silvestre-marques@telecom.pt (LUIS MARQUES) - Fri, 16 Aug 2019 07:05:57 EDT
The external table files should have all the DELIMITER and RECORDEND

characters properly escaped. Are you copying the files between servers? Is the

database encoding the same for the origin and destination? What are the

DB_LOCALE and CLIENT_LOCALE environment variables set to ?



Best regards,

Luis Marques









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41782]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Load from external table issues
Posted by: aleksandar.ivanovski@gmail.com (ALEKSANDAR IVANOVSKI) - Thu, 15 Aug 2019 11:17:39 EDT
Dear All,



I am doing unload/load to external tables in order to speed up the process of

dbexport/dbimport for huge tables. However, I get an error



26168: Conversion err:(file,offset,reason,col)=(xxxx)

so my assumption is that we have some data in the char fields in the tables

that is recognized as delimiter

Source and destination systems are the same, Informix 11.7FC 4 on AIX 7.1,

same environment, same pretty much everything. We have tried few options for

the delimiter sign (including format "informix" ) but no luck. Any idea how to

bypass this behavior.

Actually there is some special data in the char columns such as \n \t that are

causing troubles.



Here are the export import commands used:



UNLOAD



set pdqpriority 80;



drop table if exists glb_stavka_in_ext;



create external table glb_stavka_in_ext

sameas glb_stavka_in

using (

datafiles (



'DISK:/export_dir/migracija_test/unload_na_tabeli/test/glb_stavka_in.unl3'),DELIMITER

'|');



insert into glb_stavka_in_ext

select * from glb_stavka_in where data_valuta < '05-01-2014';



LOAD:



set pdqpriority 80;



drop table if exists glb_stavka_in_ext;



create external table glb_stavka_in_ext

sameas glb_stavka_in

using (

datafiles

('DISK:/export_dir/migracija_test/unload_na_tabeli/test/glb_stavka_in.unl3'),DELIMITER

'|',

express);



insert into glb_stavka_in

select * from glb_stavka_in_ext;



We are following the document

https://advancedatatools.com/Downloads/AdvancedDataTools-Webcast-DB_Migrations_2_MikeWalker.pdf

where the syntax is as follows:



set pdqpriority 25;

create external table bigtab_ext

sameas bigtab

using (datafiles

("DISK:/migrate/bigtab.unl1",



"DISK:/migrate/bigtab.unl2"),



format "informix");



insert into bigtab_ext

select * from bigtab;



set pdqpriority 25;

drop table if exists bigtab_ext;

create external table bigtab_ext

sameas

bigtab_load

using (datafiles

("DISK:/migrate/bigtab.unl1",



"DISK:/migrate/bigtab.unl2"),



format "informix");



alter table bigtab_loadtype (raw);

insert into bigtab_load

select * from bigtab_ext;



Any idea is highly appreciated

Thank you,

Aleksandar









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41781]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

AggregateRange with unamed type
Posted by: romain.mathonet@i-pulses.be (ROMAIN MATHONET) - Wed, 14 Aug 2019 05:43:07 EDT
hello everyone,

i'm working on IDS 14.10 and I'm trying to collect the results of

aggregaterange on certain fields of my timeSeries but not all of them. I have

found the following which works:



create row type elemval2 (

tstamp datetime year to fraction(5),

tstamp2 datetime year to fraction(5),

tmp real,

tmp2 real);



select

AggregateRange('min($timestamp2),avg($high),min($low)',stock_data)::elemval2

from daily_stocks2;



However I can't seem to find a way to do the same select without using a named

row type. What I would like to do is something like this:



select

AggregateRange('min($timestamp2),avg($high),min($low)',stock_data)::ROW(

tstamp datetime year to fraction(5),

tstamp2 datetime year to fraction(5),

tmp real,

tmp2 real)

from daily_stocks2;



If anyone has a clue on how to avoid using a named type i would love to hear

it!



Thank you a lot in advance,

Best regards,

Romain









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41780]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: enumerate contents of sbspace?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 09 Aug 2019 19:46:55 EDT
P.S. In a related thread a couple years ago, we discussed going "the other

way".



So, I guess I could go through every database, and find all tables that have a

column that "lives" in the specified sbspace. Sort of "brute force", but

should work.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41779]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

enumerate contents of sbspace?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 09 Aug 2019 19:17:17 EDT
IDS 12.10FC12

Solaris 10 1/13



How might it be possible to exhaustively enumerate all objects within a given

sbspace?



That is, for each object in the specified sbspace, list the database, table,

and column which is associated with that object?



Thank you.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41778]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Moving the logs, or not?
Posted by: alexandre_marini@hotmail.com (ALEXANDRE MARINI) - Fri, 09 Aug 2019 05:27:42 EDT
I almost forgot one important thing: security!

If you, for any reason, be with one offline chunk on your logical log dbspace,

for example, your engine might not crash!



A good point, right?



HTH

Best regards

Alexandre Marini









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41777]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

I almost forgot one important thing: security!

If you, for any reason, be with one offline chunk on your logical log dbspace,

for example, your engine might not crash!



A good point, right?



HTH

Best regards

Alexandre Marini









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41777]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Reader v