| Author |
Message
|
| ccarrillo |
 Posted: Fri Oct 28, 2016 8:40 am Post subject: SET MQSI_FILENODES_MAXIMUM_RECORD_LENGTH |
 |
|
Newbie
Joined: 28 Oct 2016
Posts: 9
|
Hello, i'm new on iib10 and i have to set MQSI_FILENODES_MAXIMUM_RECORD_LENGTH to 500 MB, how to do this and where?.
Thanks in advance |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Oct 28, 2016 8:59 am Post subject: Re: SET MQSI_FILENODES_MAXIMUM_RECORD_LENGTH |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ccarrillo wrote: |
| i have to set MQSI_FILENODES_MAXIMUM_RECORD_LENGTH to 500 MB, how to do this and where?. |
Wherever and however you'd set an environment variable in the OS you're using and that you don't mention.
You then need to make sure you've got plenty of memory (because you're going to burn through that) and ask yourself why you're using a design that has 500Mb records. There are very few valid use cases for that and I'd be surprised if you have one.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Oct 28, 2016 9:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| ccarrillo |
| Posted: Fri Oct 28, 2016 9:16 am Post subject: Re: SET MQSI_FILENODES_MAXIMUM_RECORD_LENGTH |
|
|
Newbie
Joined: 28 Oct 2016
Posts: 9
|
| Vitor wrote: |
| ccarrillo wrote: |
| i have to set MQSI_FILENODES_MAXIMUM_RECORD_LENGTH to 500 MB, how to do this and where?. |
Wherever and however you'd set an environment variable in the OS you're using and that you don't mention.
You then need to make sure you've got plenty of memory (because you're going to burn through that) and ask yourself why you're using a design that has 500Mb records. There are very few valid use cases for that and I'd be surprised if you have one. |
I'm using IBM AIX Version 7.1 OS , i have to set a FileInput node Record Detection property to Whole File, becouse i need transfer this entire file to other location where Sqlloader must find , but i don't know how to set this environment variable on AIX. thanks for reply. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Oct 28, 2016 9:30 am Post subject: Re: SET MQSI_FILENODES_MAXIMUM_RECORD_LENGTH |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ccarrillo wrote: |
| I'm using IBM AIX Version 7.1 OS |
Then it's in the .profile of the user running your broker.
| ccarrillo wrote: |
| i need transfer this entire file to other location where Sqlloader must find |
So why are you using IIB? It's the most expensive way (both in terms of $ cost and resource cost) to simply move a file from one place to another. AIX has much more suitable tools and products available.
What do you plan to do when the file grows past 500 Mb?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ccarrillo |
| Posted: Fri Oct 28, 2016 9:52 am Post subject: Re: SET MQSI_FILENODES_MAXIMUM_RECORD_LENGTH |
|
|
Newbie
Joined: 28 Oct 2016
Posts: 9
|
| Vitor wrote: |
| ccarrillo wrote: |
| I'm using IBM AIX Version 7.1 OS |
Then it's in the .profile of the user running your broker.
| ccarrillo wrote: |
| i need transfer this entire file to other location where Sqlloader must find |
So why are you using IIB? It's the most expensive way (both in terms of $ cost and resource cost) to simply move a file from one place to another. AIX has much more suitable tools and products available.
What do you plan to do when the file grows past 500 Mb? |
You're rigth, can you tell me which tool to use for move files?
Thanks in advance . |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Oct 28, 2016 9:59 am Post subject: Re: SET MQSI_FILENODES_MAXIMUM_RECORD_LENGTH |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| ccarrillo wrote: |
| You're rigth, can you tell me which tool to use for move files? |
Ask your AIX administrators.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| timber |
| Posted: Sat Oct 29, 2016 2:34 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| Quote: |
| i have to set a FileInput node Record Detection property to Whole File, becouse i need transfer this entire file to other location |
Not true.
You can set Record Detection to 'Fixed Length' and set the FileOutput node to 'Record is unmodified data'. The FileInput node read the file in smaller chunks and append each chunk to the output file. Don't forget to wire up the End Of Data terminal on the FileOutput node. |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Oct 31, 2016 4:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| timber wrote: |
| Quote: |
| i have to set a FileInput node Record Detection property to Whole File, becouse i need transfer this entire file to other location |
Not true.
You can set Record Detection to 'Fixed Length' and set the FileOutput node to 'Record is unmodified data'. The FileInput node read the file in smaller chunks and append each chunk to the output file. Don't forget to wire up the End Of Data terminal on the FileOutput node. |
I'd still question the value and utility of using IIB for a simple lift and shift.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
