asked by:
0 pts.

asked by:
0 pts.

Dynamic sql with delete and commit
Hi, I need to delete rows from different db2 tables in COBOL with commit in between after some 100 or 200 rows. Is there any away I can restrict my delete statement for some particular rows as in Select for fetch first 100 rows only. The values of table names will be known only during [...]

Answer Question   |  June 25, 2008  11:18 AM
DB2, DB2 administration, DB2 Everyplace
asked by:
0 pts.

LDAP in DMZ
We are using LDAP for Internal environment as an Enterprise directory having lot of application and user specific data. There is requirement to access LDAP from external network also. Bearing that in mind we shall have LDAP Server in DMZ to service external applications. Here we are using Sun Directory Server 5.2. What are the [...]

Answer Question   |  June 29, 2005  6:44 PM
Application security, Biometrics, Database, DataCenter, Digital certificates, Encryption, Exchange, IBM/Tivoli, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security, Security tokens, Single sign-on, Waveset/Sun Micro
asked by:
0 pts.

Losing the GUI for Outlook Web Access after login
I am having an issue on Exchange Server 2003. When a user logs on to Outlook Web Access via our secure site, there is no GUI interface. It turns into what looks like a “directory” structure that is completely unuseable. We also host our website on this server, and when we first put the site [...]

Answer Question   |  June 28, 2005  1:30 PM
Application management, Client management, Database issues, DataManagement, E-mail applications, Exchange, Exchange 2003, Installation, Maintenance, Migration, Outlook, Tech support
asked by:
0 pts.

function to subtract 200 days from date
I need to write the filter condition in cognos as follows: YRMOSDOS between (&YRMOSDOS – 200) AND (&YRMOSDOS) where YRMOSDOS is in date form. How do I achieve it? The database is in db2. Decimal function does not work. Please help. Thanks a lot.

Answer Question   |  June 29, 2005  11:20 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, Development, MySQL, Software testing
asked by:
0 pts.

Calculation at database level
Hi! Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to calculate the [...]

Answer Question   |  June 13, 2005  3:47 PM
Database, DB2, Development, Oracle, Security, Software Quality Assurance, Software testing
asked by:
0 pts.

Exchange 2003 STD database keeps filling up
Our Exchange database keeps filling up and shutting us down. We have 2003 Std so I know the limit is 16GB. When we view the mailboxes in the management concole nobody exceeds 50MB, we have 150 users, which should total no more than 7.5GB. > Where is the other space being taken up? > Is [...]

Answer Question   |  June 16, 2005  8:26 AM
Administration, Database issues, Exchange, Exchange 2003
asked by:
5 pts.

Exchange 2K IM Server Question
I have setup a test lab for E2K IM. I installed a separate Win2K server in the test AD Domain; all the latest updates etc. Installed the IM portion of the installation. I ran SP3 on the new server and and reapplied SP3 on the current E2K server that hosts email only. In SM i [...]

Answer Question   |  June 13, 2005  8:19 AM
Active Directory, Administration, AOL, Application management, Client management, Database issues, DataCenter, DataManagement, DHCP, Disaster Recovery, DNS, E-mail applications, Ethernet, Exchange, Exchange 2000, Exchange Server ActiveSync, Hardware, Help Desk, HTTP, IMAP4, Installation, Instant Messaging, Lotus Domino, Mail protocols, Maintenance, Microsoft Windows, Migration, Network management software, Networking, Networking services, Outlook, Security management, Servers, SMTP, Tech support, Third-party services, Windows, Windows 2000 Server, Yahoo
asked by:
0 pts.

Changing the statement heap parameter on iSeries
Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error “SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can [...]

Answer Question   |  June 9, 2005  6:10 AM
Application software, Availability, Backup & recovery, CIO, Computer Associates, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, DB2 Implementation, Development, E-business, Hardware, IT architecture, Modeling, Operating system platforms, Performance/Tuning, Physical security, Services, Space/structure, Storage, Tech support, Third-party services, UDB for iSeries/i5, Vendors
asked by:
0 pts.

Unable to send files using Msn messenger
Hi whenever i am trying to send any files using msn messenger, its giving me a error message stating that contact the administrator or contact your isp and filed could not be transferred. Previously i was able to transfer the files with the same msn and it used to work fine. My friend was trying [...]

Answer Question   |  May 27, 2005  9:49 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding, Security
asked by:
10 pts.

Global SMS Web service API
Are there any other Global SMS Web servics out there besides StrikeIron’s offering? This service lets you build global text messaging functionality into your own applications without having to know the carrier of the provider. They are offering a trial with 5 free SMS messages: http://www.strikeiron.com/htmls/pws_global_sms_pro.aspx What do you think?

Answer Question   |  June 2, 2005  10:36 PM
BEA, BEA WebLogic, Cape Clear Cape Connect, Hardware, IBM, Microsoft .NET, Microsoft Windows, Oracle, PeopleSoft, Plumtree, SAP, Sybase, Systinet WASP, TIBCO
asked by:
0 pts.

reusedlt *yes
Hi, Has reusedlt *yes behavior changed with V5R3? When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one. Anyone run into this before? [...]

Answer Question   |  November 1, 2011  2:52 PM
Backup & recovery, Data center operations, Data mining/analysis, Data warehousing applications, Database Management Systems, DB2, DB2 administration, DB2 Implementation, Disaster Recovery, Hardware, Help Desk, i5, IBM, iSeries, OS/400, Performance/Tuning, Security management, Software Quality Assurance, System monitoring, Tech support, tips and tricks, Tools
asked by:
0 pts.

asked by:
0 pts.

Bad spyware infection? Take it to the clinic
Hello, We recently ran our first Windows Security Clinic on SearchWindowsSecurity.com. We presented an administrator’s hacking dilemma, and our three Windows security gurus (the “doctors”) provided their diagnoses and possible courses of action to address, recover from and prevent security breaches. >> Windows Security Clinic: You’ve been hacked! Now what? http://searchwindowssecurity.techtarget.com/tip/1,289483,sid45_gci1081819,00.html I’m writing today because [...]

Answer Question   |  May 12, 2005  9:57 PM
Application security, backdoors, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, Secure Coding, Security, Spyware, Trojans, Viruses, worms
asked by:
0 pts.

Oracle 9i Query Time
What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.

Answer Question   |  May 6, 2005  11:45 AM
Database issues, Database Management Systems, in use in organization, Oracle, s, Total size of the database, Very Large Databases
asked by:
0 pts.

Data vs. perimeter vs. network security
A short time ago, author Wes Noonan wrote some tips for SearchWindowsSecurity.com about <a href=http://searchwindowssecurity.techtarget.com/originalContent/0,289142,sid45_gci1007026,00.html>deperimeterization</a>. He explained how security is always pitted against business needs, and perimeters have become porous because businesses require traffic from SMTP, HTTP or VPNs to pass through the firewall. He then offered techniques for keeping data safe in spite of [...]

Answer Question   |  May 4, 2005  4:36 PM
Administration, Application security, Architecture/Design, backdoors, Biometrics, Compliance, configuration, CRM, Current threats, Database, Desktop vs network-based firewalls, Digital certificates, Disaster Recovery, Documentation, Encryption, Exchange, Features/Functionality, Firewalls, Forensics, Hacking, Host-based IDS/IPS, human factors, Identity & Access Management, IDS vs IPS, IDS/IPS management, Incident response, Installation, Instant Messaging, Intrusion management, Managed security services, Management, Network security, Network-based IDS/IPS, Networking, Outsourcing/Managed services, patching, PEN testing, Platform Security, Policies, Product evaluation, provisioning, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, Security tokens, Service and support, Signature updating/Management, Single sign-on, Software vs appliance, Spyware, Trojans, Viruses, VPN, Vulnerability Assessment & Audit, vulnerability management, Wireless, worms
asked by:
0 pts.

Inserting data into a vargraphic data type field
How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES(‘TEST’) This gives a SQL error Please let me know how I can acheive it.

Answer Question   |  May 4, 2005  9:44 AM
Application software, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, Development, Hardware, Help Desk, IT architecture, Migration, Modeling, Operating system platforms, Services, Tech support, Third-party services, UDB for iSeries/i5, Vendor support
asked by:
0 pts.

Reference book for JCL
What is the best reference book for JCL ?

Answer Question   |  May 5, 2011  6:14 AM
DB2 Implementation
asked by:
0 pts.

Locate databases on an AS400
Greetings. I recently “inherited” an AS400 model 720 after another staff member left. I’m a “newbie” with this system, but have been tasked to find the active DB2 databases still in use on the system. I can check my BRMS logs and see which libraries have changed from day to day, but I am unsure [...]

Answer Question   |  April 25, 2005  3:45 PM
Database, DB2, Oracle, Tech support
asked by:
0 pts.