List of Contributions

Josef Albert

Contact Details

My Content

1 to 14 of 14 total
Posted By Josef Albert Mar 18, 2021 11:31 AM
Found In Egroup: Informix
\ view thread
Hi, is there any way to get the cpu usage per session? I don't want the CPU time since the session starts like here: How to isolate High CPU usage for Informix I want to see the current cpu usage / session to find the sessions causing the cpu to run at 100%. Or is there any other way to determine these ...
Posted By Josef Albert Dec 21, 2020 4:30 AM
Found In Egroup: Informix
\ view thread
Thank you, i'll try it. :) ------------------------------ Josef Albert ------------------------------
Posted By Josef Albert Dec 17, 2020 6:22 AM
Found In Egroup: Informix
\ view thread
Hi, are there any example sql scripts available for the benchmark? Like this: (Appendix) https://www.ibm.com/developerworks/data/library/techarticle/dm-1104tuneinformix1/index.html Unfortunately i can't find the database used in this example. ------------------------------ Josef Albert ...
Posted By Josef Albert Dec 17, 2020 4:14 AM
Found In Egroup: Informix
\ view thread
Hi Eric, i forget to say that the benchmark will run under windows. Is this possible? Thanks. ------------------------------ Josef Albert ------------------------------
Posted By Josef Albert Dec 17, 2020 2:14 AM
Found In Egroup: Informix
\ view thread
Hi, is there any tool available for benchmarking / comparing different servers? I'm reading about BenchmarkSQL used by the fasted DBA contest... But i can't find the fork that supports informix. Thx. ------------------------------ Josef Albert ------------------------------
Posted By Josef Albert Dec 15, 2020 9:00 AM
Found In Egroup: Informix
\ view thread
Hi, i've the problem that sometimes (random) onstat commands fails with following error: 14:53:31 shmat: [22]: operating system error 14:53:31 Client could not attach server shared memory segment, use IFX_XFER_SHMBASE. MapViewOfFileEx: w32ec=487 at nt_shm.c:735 onstat: Cannot attach to shared memory. ...
Posted By Josef Albert Nov 25, 2020 1:14 AM
Found In Egroup: Informix
\ view thread
The services file is not used when i type the port number directly (e.g. 15000 in my example) in the sqlhosts. So in this specific case it couldn't be a services file issue. Or am i being wrong here? ------------------------------ Josef Albert ------------------------------
Posted By Josef Albert Nov 24, 2020 2:54 PM
Found In Egroup: Informix
\ view thread
Hi, i finaly found the issue. It has nothing to do with the OS or something else. It's just a stupid informix bug. If there is no new line or space after the last line in the sqlhosts file the last char of the last line gets duplicated. With this sqlhosts settings informix tries to connect to slrz-t-db01: ...
Posted By Josef Albert Nov 5, 2020 2:57 AM
Found In Egroup: Informix
\ view thread
Hi, IDS: 14.10 FC3 Primary: Win Srv 2012 R2 RSS: Win 2019 I don't find a reference about supported os in the machine notes. But here i can see that you need Win 2016 or higher for 14.10: https://www.ibm.com/support/pages/node/320749 I'll migrate the primary to 2019 and after this i try to activate the ...
Posted By Josef Albert Nov 2, 2020 12:21 PM
Found In Egroup: Informix
\ view thread
Yes, i do. Can i've a problme with 2 different os? Primary is 2012 R2, RSS 2019. ------------------------------ Josef Albert ------------------------------
Posted By Josef Albert Nov 2, 2020 12:04 PM
Found In Egroup: Informix
\ view thread
Hi Art, After the restore completes, you MUST NOT run onmode -m before running onmode -d RSS primarysrv! I know, i did it just to check the archive and the server. (sysdatabases) The method is: restore the secondary from an archive taken from the primary if the logical log that was current ...
Posted By Josef Albert Nov 2, 2020 10:11 AM
Found In Egroup: Informix
\ view thread
Hi, i receive this message when i try to finalize the rss with "onmode -d RSS primarysrv". The primary is doing fine, no problems. Also the RSS is doing fine when i try to take him online with "onmode -m" after the restore with "ontape -p". But when i try "onmode -d RSS primarysry" i receive the errors. ...
Posted By Josef Albert Oct 27, 2020 10:57 AM
Found In Egroup: Informix
\ view thread
Hi Art, yes, i used the same steps as i used before with 12.10 instances: ------------------------------ Josef Albert ------------------------------
Posted By Josef Albert Oct 20, 2020 10:28 AM
Found In Egroup: Informix
\ view thread
Hi, im trying to create a RSS instance with ids 14.10 following this guide: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.admin.doc/ids_admin_1000.htm With 12.10 this steps are working fine, but with 14.10 i'm not able to bring the rss instance online. It fails with following messages: ...