Stored Procedure Error
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]
Answer Question
| December 17, 2004 2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]
Answer Question
| December 17, 2004 2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
OS/400 descriptions of files in Library QUSRSYS.
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the “Go Backup” and “Go Cleanup” configurations are stored but explanations of the other files in this library will also be extremly usefull for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
Hi There, Does anyone have descriptions of the files and their contained information for the files in Library QUSRSYS. In particular I am looking for where the “Go Backup” and “Go Cleanup” configurations are stored but explanations of the other files in this library will also be extremly usefull for High Availability purposes. Thanks. Best [...]
Answer Question
| December 6, 2004 9:02 AM
AS/400, Backup & recovery, Hardware, i5, IBM, Installation, iSeries, OS/400, Performance/Tuning, Server consolidation, Servers, tips and tricks, Tools
who integrated Domino Admin Server Monitoring in CA Unicenter NSM Console?
We only want one monitor in our IT production environment: CA Unicenter NSM Console. Therfore we want that all irregular events of Domino Administrator Server Monitoring are sent to CA Unicenter NSM Console. Has anybody done this or can give hints or tips? Thanks a lot.
Answer Question
| December 3, 2004 10:55 AM
Computer Associates, Data center design, Data center operations, DataCenter, DHCP, Disaster Recovery, DNS, Hardware, IBM, Implementation, Information risk management, IT architecture, Networking services, Security management, Space/structure, Storage, Tech support
We only want one monitor in our IT production environment: CA Unicenter NSM Console. Therfore we want that all irregular events of Domino Administrator Server Monitoring are sent to CA Unicenter NSM Console. Has anybody done this or can give hints or tips? Thanks a lot.
Answer Question
| December 3, 2004 10:55 AM
Computer Associates, Data center design, Data center operations, DataCenter, DHCP, Disaster Recovery, DNS, Hardware, IBM, Implementation, Information risk management, IT architecture, Networking services, Security management, Space/structure, Storage, Tech support
HBA not showing WWN
A SearchStorage.com reader asks: WE have a data center server, 2003 servers and two HBAs in each node. Both the cards are Emulex Fibre Channel Cards. One card is already in working condition. We have recently added the second HBA card. The driver was updated, and I am able to detect two HBAs from the [...]
Answer Question
| August 6, 2009 10:27 AM
3PAR, Adapters/Interfaces, ADIC, AMCC, AppIQ, Arrays, Backup & recovery, Blue Arc, Brocade, Cisco, CNT, Commvault, Commvault Systems, Computer Associates, CreekPath, Data Core Software, Dell, Disk drives, EMC, Emulex, Exabyte, FalconStor, Fibre channel, Finisar, Fujitsu, Hitachi Data Systems, HP, IBM, Imation, InterSAN, LSI Logic, McData, NAS, Network Appliance, NTP Software, Optical, Overland Data, Power Quest, Procom Technologies, Quantum, RAID, SAN, SCSI, SEA, Sony, Spectra Logic, Storability, Storage, Storage management, Storage products and equipment, Storage servers, StorageTek, Storcase technology, Sun Microsystems, Syncsort, Tape drives/Libraries, Tivoli, TrueSAN, Veritas, Xiotech
A SearchStorage.com reader asks: WE have a data center server, 2003 servers and two HBAs in each node. Both the cards are Emulex Fibre Channel Cards. One card is already in working condition. We have recently added the second HBA card. The driver was updated, and I am able to detect two HBAs from the [...]
Answer Question
| August 6, 2009 10:27 AM
3PAR, Adapters/Interfaces, ADIC, AMCC, AppIQ, Arrays, Backup & recovery, Blue Arc, Brocade, Cisco, CNT, Commvault, Commvault Systems, Computer Associates, CreekPath, Data Core Software, Dell, Disk drives, EMC, Emulex, Exabyte, FalconStor, Fibre channel, Finisar, Fujitsu, Hitachi Data Systems, HP, IBM, Imation, InterSAN, LSI Logic, McData, NAS, Network Appliance, NTP Software, Optical, Overland Data, Power Quest, Procom Technologies, Quantum, RAID, SAN, SCSI, SEA, Sony, Spectra Logic, Storability, Storage, Storage management, Storage products and equipment, Storage servers, StorageTek, Storcase technology, Sun Microsystems, Syncsort, Tape drives/Libraries, Tivoli, TrueSAN, Veritas, Xiotech
Best IDE for building JSP pages
This is just for educational purposes. I want to build some JSP pages for a university project, and I’m looking for a J2EE IDE (better if free), but I’m, not sure which is best or easiest to use. I have taken a look to Net Beans 3.6 and I like it, but it’s too heavy [...]
Answer Question
| November 9, 2004 2:04 PM
BEA Systems, BEA WebLogic, C, Computer Associates, HTML, IBM, IBM WebSphere, J2EE, Java, JavaScript, JBoss, JSP, Servers, Sun, Sun ONE Application Server, Web development tools, WebSphere Studio
This is just for educational purposes. I want to build some JSP pages for a university project, and I’m looking for a J2EE IDE (better if free), but I’m, not sure which is best or easiest to use. I have taken a look to Net Beans 3.6 and I like it, but it’s too heavy [...]
Answer Question
| November 9, 2004 2:04 PM
BEA Systems, BEA WebLogic, C, Computer Associates, HTML, IBM, IBM WebSphere, J2EE, Java, JavaScript, JBoss, JSP, Servers, Sun, Sun ONE Application Server, Web development tools, WebSphere Studio
Best rules of thumb?
What are five best rules of thumb when reviewing output from system monitors for preventing future problems. The system monitors could be any SMF/RMF MICS TSO/MON MXG OMEGAMON system monitor type report for reporting on the mainframe. Example might be 1. sustained CPU utilization over 85% 2. Long I/O ques 3. large variation in on-line [...]
Answer Question
| August 6, 2009 5:39 PM
Availability, Capacity planning, EMC, Hardware, Hitachi Data Systems, IBM, Integration with other platforms, Mainframe, Storage products and equipment, Tech support, Third-party services, Vendor support
What are five best rules of thumb when reviewing output from system monitors for preventing future problems. The system monitors could be any SMF/RMF MICS TSO/MON MXG OMEGAMON system monitor type report for reporting on the mainframe. Example might be 1. sustained CPU utilization over 85% 2. Long I/O ques 3. large variation in on-line [...]
Answer Question
| August 6, 2009 5:39 PM
Availability, Capacity planning, EMC, Hardware, Hitachi Data Systems, IBM, Integration with other platforms, Mainframe, Storage products and equipment, Tech support, Third-party services, Vendor support
Lotus Script Error Message: Subscript out of range.
I’ve recently taken over support of a homegrown Notes database. An agent runs daily in this database on all documents and pulls data from a flat file (which lives on the same server as database) and uses subroutines to process adds, deletes and changes to person docs in a Name and Address Book. Recently it’s [...]
Answer Question
| September 24, 2004 9:52 AM
Development, Exchange, IBM, Lotus Domino
I’ve recently taken over support of a homegrown Notes database. An agent runs daily in this database on all documents and pulls data from a flat file (which lives on the same server as database) and uses subroutines to process adds, deletes and changes to person docs in a Name and Address Book. Recently it’s [...]
Answer Question
| September 24, 2004 9:52 AM
Development, Exchange, IBM, Lotus Domino
DB2 Z/os IRLMWT parm
We are considering lowering the lockwait time from the two minute default to 60 seconds and then possibly even lower. What do you have it set to today? Have you had any experience with having it set well below one minute?
Answer Question
| May 14, 2004 1:33 PM
IBM, Instant Messaging, OS/390, OS/390/z/OS, UDB for mainframe, z/OS
We are considering lowering the lockwait time from the two minute default to 60 seconds and then possibly even lower. What do you have it set to today? Have you had any experience with having it set well below one minute?
Answer Question
| May 14, 2004 1:33 PM
IBM, Instant Messaging, OS/390, OS/390/z/OS, UDB for mainframe, z/OS
