midrange.com -- midrange-l mailing list

Re: massive document storage in the IFS - how to handle Mimix

Joe Pluta — 2013-05-18T18:20:30-05:00

A limit on the size of the CLOB support in SQLRPGLE. Joe Would that be a self-imposed limit, or a limit imposed due to interfacing with system "space" objects in /QSYS.lib [e.g. *USRSPC] which has that similar [but somewhat smaller] limit? http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzlimtabs.htm "... Table 3. String LimitsString Limits DB2 for i Limit ... Maximum length of CLOB (in bytes) 2 147 483 647 ... "

Re: codd's 12 Rules

Vernon Hamberg — 2013-05-18T17:27:12-05:00

There are surely a variety of possible implementations that could enable the QTEMP library to be tracked to the catalogs, thus enabling constraints to be created into QTEMP. The big issue that is not so easily, the enabling the capability to query the catalogs [without an API call to know what to search instead of] using either of the names QTEMP or SESSION.

Re: massive document storage in the IFS - how to handle Mimix

Vernon Hamberg — 2013-05-18T17:20:39-05:00

Re: massive document storage in the IFS - how to handle Mimix

Vernon Hamberg — 2013-05-18T16:57:24-05:00

Re: binding directories? one big one? or smaller, specific ones?

CRPence — 2013-05-18T15:28:18-05:00

Rather than an explanation for why the intended\original reply never arrived at the NewsGroup nor the archives, I had hoped to elicit a response that included the text of the missing intended\original reply. That is to suggest, I am wondering... What did I miss?

Re: massive document storage in the IFS - how to handle Mimix

CRPence — 2013-05-18T13:45:03-05:00

Would that be a self-imposed limit, or a limit imposed due to interfacing with system "space" objects in /QSYS.lib [e.g. *USRSPC] which has that similar [but somewhat smaller] limit? http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzlimtabs.htm "... Table 3. String LimitsString Limits DB2 for i Limit ... Maximum length of CLOB (in bytes) 2 147 483 647 ... "

Re: codd's 12 Rules

CRPence — 2013-05-18T13:16:54-05:00

Re: codd's 12 Rules

CRPence — 2013-05-18T13:15:03-05:00

Undated, /dated/ material? Seems from the given link, for lack of any other apparent implication provided, that "today" represents the year 1994.

Re: Question about support related to Windows 7

CRPence — 2013-05-18T11:45:32-05:00

<<SNIP>> Must start with a letter. Do not start with a Q. Why not a Q? Something to do with Q1234 being the same as 1234.

Re: massive document storage in the IFS - how to handle Mimix

Richard Schoen — 2013-05-18T11:27:53-05:00

I would imagine now you would start managing large database file backups vs IFS backups. Now what does your nightly DB backup window look like ? It's interesting that one of the strengths and great weaknesses of tools like MS Sharepoint is that they store all documents in the database. Larger DB backup, less file backup or larger file backup less DB backup. I suppose either has merits. In the case of Sharepoint there are 3rd party apps that allow the files to be stripped from the DBs back to the file system...

Re: massive document storage in the IFS - how to handle Mimix

Joe Pluta — 2013-05-17T22:54:43-05:00

The size of the file directly mirrors the size of the CLOB storage (since the key data is measured in 100s of bytes vs. the CLOB measuring in 100s of KB, the non-CLOB data is negligible). Note there are still practical issues: the maximum size for a CLOB field is around 16MB; I wouldn't store files larger than that in the database anyway. But for anything smaller you're in good shape. Generally speaking SAV performance is a lot faster. We actually had to exclude the folders containing millions of files just...

Re: Question about support related to Windows 7

John McKee — 2013-05-17T22:23:00-05:00

user recreate computer. contents. check presumably from Windows, requesting a user name and password. <<< I called IBM support. Initially, I was routed to support for i issues. think, the i. he detailed. his about PF, (it was told them. do the archives. the waste. Otherwise, new please -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsu...

Re: Question about support related to Windows 7

John Jones — 2013-05-17T22:07:22-05:00

user recreate computer. check presumably from Windows, requesting a user name and password. <<< I called IBM support. Initially, I was routed to support for i issues. the i. he detailed. his PF, (it was told them. do the the waste. Otherwise, new -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: ...

Re: Question about support related to Windows 7

John McKee — 2013-05-17T21:55:56-05:00

Re: Question about support related to Windows 7

John McKee — 2013-05-17T21:49:22-05:00

user recreate computer. check presumably from Windows, requesting a user name and password. <<< I called IBM support. Initially, I was routed to support for i issues. the i. he his PF, (it was told them. do the the waste. Otherwise, new -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lis...

Re: massive document storage in the IFS - how to handle Mimix

Bdietz400 — 2013-05-17T21:41:17-05:00

Re: codd's 12 Rules

Booth Martin — 2013-05-17T21:40:17-05:00

Re: codd's 12 Rules

Vernon Hamberg — 2013-05-17T21:36:12-05:00

Rule 0: The system must qualify as relational, as a database, and as a management system. Does IBM i DB not qualify as relational? As a database? As a management system? Isn't that a rather narrow interpretation of the rule? And a narrow interpretation of a management system? -Nathan

Re: cloud services with new development on IBM i on Power

Vernon Hamberg — 2013-05-17T21:26:47-05:00

I don't see any mention of Windows or Linux in the title. Nor in the original post. I believe you stated your intention to derail this thread in your opening comment: "I don't see a huge ecosystem expansion for IBM i ..." -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before ...

Re: codd's 12 Rules

Vernon Hamberg — 2013-05-17T21:25:14-05:00

I see this question in the exact same light I see questions like 'What is the total number of transistors used in the Power 7?' I'm trying to work out John's intent by asking myself what I'd do if I had The Answer. I can't imagine what use the answer is outside of a trivia contest. Let's say for the sake of discussion that DB2 for i violates Rule 0. Let's also posit that DB2 LUW 10.1 violates Rule 9. Are they both 'equally relational' because they only missed by one? Are all the Rules equal in weight, in i...